VLOOKUP Function

[Guest]

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

 

[Guest]

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

 

[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

 

[Guest]

Pete

Can i email you what my Spreadsheet looks like

 

[Pete_UK]

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

Pete

 

[Pete_UK]

Email received, and I have sent you back an amended file.

Pete