Need help

C

croder

My problem, I have a price sheet with product codes, item description,
size, weight, $,...
I would like to create worksheet, maybe on a different page or below
the existing price list, that will import all the info(values) of the
row by entering the product code.
for instance: product code is *S100*,
by enterin the code in a cell , it should import all other values, like
size, weight, price,.... in the same row.
Can that be done?
Thanks
 
N

Niek Otten

Use MATCH to fins the line number in the table

=MATCH(C1,A1:A100,0) (in D1, Product number in C1)

Use INDEX to extract the values

=INDEX(A1:A100,D1,2)
=INDEX(A1:A100,D1,3)

etc
 
Top