MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vlookup table


Posted by rakinder padam on September 07, 2001 5:58 AM

i am doing a project, which i can send to u over email, i need to do a VLOOKUP table but i hae tried, can't do it linking to another worksheet.
In one worsheet ther is code and prices and i need to create a VLookup table to let the price automatically come up in the other worksheet when i type the code in. how do i do that?
it needs to be done by end of weekend, very urgent, please help


Posted by Robb on September 07, 2001 6:34 AM

Try this formula.

=VLOOKUP(A1,[NameofOtherWorkBook]Sheet2!A2:B7,2,FALSE)

Put this in B1 and the price in A1. This assumes the lookup array is A1:B7 on sheet2
of the other workbook. You could amend it to suit.

Any help?

Regards