VLOOKUP Function
 

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

VLOOKUP Function
 

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

VLOOKUP Function
 

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 -

VLOOKUP Function
 

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 -

VLOOKUP Function
 

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

Pete

On Aug 2, 1:04 am, bglee31 wrote:
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 -- Hide quoted text -

- Show quoted text -

VLOOKUP Function
 

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

Pete

On Aug 2, 1:17 am, Pete_UK wrote:
Yes, though it is 1:15am here so I won't get to look at it until
tomorrow.

Pete

On Aug 2, 1:04 am, bglee31 wrote:



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 -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -