Pete

Can i email you what my Spreadsheet looks like


"Pete_UK" wrote:

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

On Aug 1, 11:40 pm, bglee31 wrote:
the item number is column A and the description and unit price is on another
worksheet called product



"bglee31" wrote:
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- Hide quoted text -

- Show quoted text -