Not sure.

[Old Guy]

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,

 

[John]

Hi Old Guy
I would use VLOOKUP, check it out in Excel Help.
Regards
John ( Old Guy too )

 

[Max]

As mentioned by John, vlookup would come in useful

Something like this ..
Assuming the reference table in cols A and B as posted
and you have the lookup values in D1 down, eg: LNL

Place this in E1: =IF(D1="","",VLOOKUP(D1,A:B,2,0))
then copy E1 down as far as required

Always set it for an exact match (ie 4th param = zero or FALSE)
whenever you lookup text
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[xlmate]

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