VLOOKUP Function

B

bglee31

how would i get the description and unit price to automatically appear in th
eproduct thable when an item number is entered in the worksheet
 
B

bglee31

the item number is column A and the description and unit price is on another
worksheet called product
 
P

Pete_UK

You don't give us a lot to go on, but assuming you enter a product
number in A2, then put these formulae in the cells stated:

B2: =VLOOKUP(A2,product!$A$1:$C$1000,2,0)
C2: =VLOOKUP(A2,product!$A$1:$C$1000,3,0)

This assumes that your data in the product sheet occupies rows 1 to
1000 - adjust if necessary.

Hope this helps.

Pete
 
P

Pete_UK

Yes, though it is 1:15am here so I won't get to look at it until
tomorrow.

Pete
 
Top