Vba problem

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
No worries Irum, It seems you are in good hands with Venkat.

Best regards,
Trowa