Vlookup

[cobrajg]

I need a formula that will do the following.

Formula will be in cell F3:
It will need to look at data in cell L4, and search for the equal value in Column A on another workbook, then report back the data that is in the same row but Column G.

I hope I am explaining this clearly.

Thanks for any help!

[Gearcutter]

Hi
Try Vlookup(L4,[Book2,xls]Sheet1!Range,7,False)
L4 is the number you want to lookup Book2 you replace with your workbook name, the same applies to the sheet number, the range will start with the column A the rows you must decide where you start and finish but the column must include column G which is the 7th, and false means it must be an exact match. hth regards Howard

[cobrajg]

Thanks Howard.

That is what I needed.