Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another #N/A Result question...Sorry
I've read and tried every conceivable posibbilty I could think of, with no
succes. The formula below results in #N/A if Q19 = nothing....how can I get a blank cell result? =IF(Q19=1,HLOOKUP(I34,G92:O97,3),IF(Q19=2,HLOOKUP( I34,G92:O97,4),IF(Q19=3,HLOOKUP(I34,G92:O97,5),IF( Q19=4,HLOOKUP(I34,G92:O97,6),"")))) Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |