Previous Topic Next Topic

Vba problem

Closed
irum - May 17, 2012 at 01:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 24, 2012 at 09:55 AM
Hello,

In sheet 2 ,I have these fields and in sheet1, I have these plus some more.
Order # PO # Item # Description Lease Rate Rental Serial Location
I want that when I enter order # in sheet 1 it compairs it with the order# column in sheet2 and on the basis of this comparision it picks lease rate,rental and put it in sheet1.
could you please help me in doing this.

Thanks

Irum



4 responses

Answer 1 / 4
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 21, 2012 at 10:18 AM
Hi Irum,

Sounds to me like you are in need of VLOOKUP.

Let's start with Column E (Lease Rate) of sheet1:
=VLOOKUP(A2,Sheet2!$A$2:$H$100,5)

Make sure you correct the search matrix (Sheet2!$A$2:$H$100) to suit your data.
Drag this formula down to fill out the column.

Apply this formula to the other columns while adjusting the last number in the formula (5) accordingly.

Hopefully I provided enough info to solve your query.

Best regards,
Trowa
0
Answer 2 / 4
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 22, 2012 at 09:13 AM
Hi Irum,

If you don't like the answer then do tell why?, instead of opening another topic.

Best regards,
Trowa
0
Answer 3 / 4
irum
May 22, 2012 at 10:48 AM
Hi Trowa

I think you mind it.Sorry if it hurts you.Infact I am new in VBA and I really dont know how to explain my question?

Sorry again.

Regards
Irum
0
Answer 4 / 4
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 24, 2012 at 09:55 AM
No worries Irum, It seems you are in good hands with Venkat.

Best regards,
Trowa
0

Similar discussions

Create folder in desktop with vba, if exist, ignore
viriato74 -
praveen -

6 responses