| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can't get lookup to work when i need it to report from a cell ref
Hi
I am trying to convert the following nested if statement to allow me to be able to choose from more than 8 variables. =IF(C98="A",$F$28,IF(C98="B",$F$37,IF(C98="C",$F$4 6,IF(C98="D",$F$55,IF(C98="E",$F$64,IF(C98="F",$F$ 73,IF(C98="G",$F$82,IF(C98="H",$F$91,"")))))))) this equation does work but i need to be able to also say if cell C98="I" but due to limitations of 7 nested ifs only i can't do this. I have tried using lookup but it doesn't allow me to create an array with the individual cell references. Note C98 is blank until i enter a letter A through H. all the references have calculations eg F37=IF(ISBLANK(B64),"",(D64/E64)) Any help would be very much appreciated Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for Work Load/Production Report Logs spreadsheet... | Excel Discussion (Misc queries) | |||
| how do i set up a work in progress report for a construction compa | Excel Worksheet Functions | |||
| Lookup does not work -copy info from the above cell | Excel Discussion (Misc queries) | |||
| Vlookup doesn't work until i edit(but not change) the lookup cell | Excel Worksheet Functions | |||
| how do I get lookup to work | Excel Worksheet Functions | |||
Threaded Mode
