Not sure.

  • Thread starter Thread starter Old Guy
  • Start date Start date
O

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,
 
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
 
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
 
Back
Top