try using VLOOKUP function in Excel

assuming C2 is where you place the value "LNL" to find
the relative code "FNM"
place this formula in D2

=VLOOKUP(A2,$A$2:$B$4,2,0)

This will find the match for you. The formula will return #N/A
if no match is found. To ignore #N/A and to show some message
or blank if no match is found, use the IF with VLOOKUP like this :

=IF(ISNA(VLOOKUP(C2,$A$2:$B$4,2,0)),"NOT IN LIST",VLOOKUP(C2,$A$2:$B$4,2,0))

Play with it and you will get the hang of it in no time.

HTH
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis


"Old Guy" wrote:

Ok, Kinda new a formuals for Execl 2003 / 2007 I have catalog numbers in column
A B
LNL FNM
BLB TNT
KBA BER
these are cross reference numbers for a fuse company, what formula would you
use that if you choose LNL and it would reference cell "B" FNM,