| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with this formula plz?
=IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;"POL",2420;"SLS",2100}),2 280),IF(A1="T",IF(A2<"",LOOKUP(A2,{"SRP",3130;"TB B",3160}),3160),""))
Bu tht above formula is actually giving me the closest value even when the condition is not met. Can someone help me in fixing this in such a way that if the condition is not met it should error out. Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with this formula plz?
I suggest you considering use VLOOKUP to get exact match as LOOKUP defaults
to "closest". "nick" wrote: =IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;"POL",2420;"SLS",2100}),2 280),IF(A1="T",IF(A2<"",LOOKUP(A2,{"SRP",3130;"TB B",3160}),3160),"")) Bu tht above formula is actually giving me the closest value even when the condition is not met. Can someone help me in fixing this in such a way that if the condition is not met it should error out. Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with this formula plz?
Try this:
=IF(A1="F",IF(A2<"",VLOOKUP(A2,{"CAS",2440;"EMF", 2410;"ENG",2660;"INP",2450 ;"POL",2420;"SLS",2100},2,0),2280),IF(A1="T",IF(A2 <"",VLOOKUP(A2,{"SRP",313 0;"TBB",3160},2,0),3160),"")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "nick" wrote in message ... =IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;" POL",2420;"SLS",2100}),2280),IF(A1="T",IF(A2<"",L OOKUP(A2,{"SRP",3130;"TBB" ,3160}),3160),"")) Bu tht above formula is actually giving me the closest value even when the condition is not met. Can someone help me in fixing this in such a way that if the condition is not met it should error out. Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with this formula plz?
Thank yoou
"RagDyeR" wrote: Try this: =IF(A1="F",IF(A2<"",VLOOKUP(A2,{"CAS",2440;"EMF", 2410;"ENG",2660;"INP",2450 ;"POL",2420;"SLS",2100},2,0),2280),IF(A1="T",IF(A2 <"",VLOOKUP(A2,{"SRP",313 0;"TBB",3160},2,0),3160),"")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "nick" wrote in message ... =IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;" POL",2420;"SLS",2100}),2280),IF(A1="T",IF(A2<"",L OOKUP(A2,{"SRP",3130;"TBB" ,3160}),3160),"")) Bu tht above formula is actually giving me the closest value even when the condition is not met. Can someone help me in fixing this in such a way that if the condition is not met it should error out. Thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with this formula plz?
Thank you
"Toppers" wrote: I suggest you considering use VLOOKUP to get exact match as LOOKUP defaults to "closest". "nick" wrote: =IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;"POL",2420;"SLS",2100}),2 280),IF(A1="T",IF(A2<"",LOOKUP(A2,{"SRP",3130;"TB B",3160}),3160),"")) Bu tht above formula is actually giving me the closest value even when the condition is not met. Can someone help me in fixing this in such a way that if the condition is not met it should error out. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
