Hi Ernie
Try

=IF(A2="","",IF(ISERROR(VLOOKUP(A2,Tariff!$A:$B,2, 0)),"",VLOOKUP(A2,Tariff!$A:$B,2,0))



--
Regards

Roger Govier




ernie wrote
it works just fine when the worksheets are named sheet1 and sheet2
and i am having difficulties fixing it.
my sheets are named 'Tariff' and 'Data Input Sheet'.
i have the codes and description on the 'Tariff' worksheet. i need
the description to appear in 'Data Input Sheet'
it starts from row5 and column B in both worksheets
Example of what it looks like:
columnB | columnC
item code | description
row5 te35434 | nissan brake pad
row6 eos920 | poineer mp3 player
arrange the formula so it works with this setting for me please..
thanks you in Advance..