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

[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

 

[Frank Kabel]

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

 

[Briggsy]

thank for your help! I'll try that