Type in code and get description in next cell - Please help ,thanks.

B

Briggsy

I am setting up a spreadsheet where I type a code in and it adds a
product description in one cell and a rate in another.

I have got the rates working fine and adding up to a total. I have
this a master sheet with the code and the amounts but I just cannot
get the formula for popping up the product description.

I would be really grateful for any help, advice or a nudge in the
right direction.

Thanks very much

Briggsy
 
F

Frank Kabel

Hi
use VLOOKUP for this. e.g.
=IF(A1="","",VLOOKUP(A1,'lookup_table'!A1:B100,2,0))
 
Top