vba problem Closed

Question

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	

	
								
Configuration: Windows 7 / Internet Explorer 8.0

TrowaD · Answer

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

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

irum · Answer

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

No worries Irum, It seems you are in good hands with Venkat.

Best regards,
Trowa

Vba problem

4 responses

Similar discussions

Subscribe To Our Newsletter!