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



Related:

4 responses

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
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
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
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