Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure.
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, |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure.
Hi Old Guy
I would use VLOOKUP, check it out in Excel Help. Regards John ( Old Guy too ) "Old Guy" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure.
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 --- "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, |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure.
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|