Product Code

[esmail]

Hi,
I have the product list in two Colum; A1..A5,
101,102,103,104,105 where as in B1.B5
is 'KeyBoard','Monitor','Mouse','Hdd','Printer'
Whenever I use any product code e.g. 103 the product name
should appear in the next column. and if i enter 106 it
should say 'No product' or error.
Please help me to solve.
with thanks..

 

[Myrna Larson]

assuming you typed the number in F5, in G5 the formula is

=IF(ISNA(VLOOKUP(F5,$A$1:$B$5,2,0)),"No product",VLOOKUP(F5,$A$1:$B$5,2,0))

 

[esmail]

-----Original Message-----
assuming you typed the number in F5, in G5 the formula is

=IF(ISNA(VLOOKUP(F5,$A$1:$B$5,2,0)),"No product",VLOOKUP (F5,$A$1:$B$5,2,0))