| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can't get lookup to work when i need it to report from a cell ref
Hi,
You can concatonate IF statements using the '&' symbol, and have lots. Not sure how many, but more than 8. Your formula would look something like: =IF(C98="A",$F$28,"")&IF(C98="B",$F$37,"")&IF(C98= "C",$F$46,"")&IF(C98="D",$F$55,"")&IF(C98="E",$F$6 4,"")&IF(C98="F",$F$73,"")&IF(C98="G",$F$82,"")&IF (C98="H",$F$91,"")&IF(C98="I",Whatever,"") Regards - Dave. |
| 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
