Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help in If error
=IFERROR(VLOOKUP($E$2,L:O,4,FALSE), "Not Avialable")
hi, I am using this (above) equation, to do lookups from 5 columns. the lookup thing is working but when there is nothing in the cell (that the function looking up) it returns 0 instead of "Not Available" (as in the equation). i want the function to show "Not available" when the cell is blank, or there is an error. thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help in If error
We answered your question in the other category. Please refrain from asking
this question in multiple places until you've given us a chance to respond. "Raz" wrote: =IFERROR(VLOOKUP($E$2,L:O,4,FALSE), "Not Avialable") hi, I am using this (above) equation, to do lookups from 5 columns. the lookup thing is working but when there is nothing in the cell (that the function looking up) it returns 0 instead of "Not Available" (as in the equation). i want the function to show "Not available" when the cell is blank, or there is an error. thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help in If error
IFERROR will return 'Not Available' only if VLOOKUP returns an error. It will
return the value VLOOKUP returns if there is no error... You may put an IF around it to check for 0 and return "Not Available"... "Raz" wrote: =IFERROR(VLOOKUP($E$2,L:O,4,FALSE), "Not Avialable") hi, I am using this (above) equation, to do lookups from 5 columns. the lookup thing is working but when there is nothing in the cell (that the function looking up) it returns 0 instead of "Not Available" (as in the equation). i want the function to show "Not available" when the cell is blank, or there is an error. thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help in If error
so what should i be using, to return "not available" when it (lookup) finds
the cell is blank or an error "Sheeloo" wrote: IFERROR will return 'Not Available' only if VLOOKUP returns an error. It will return the value VLOOKUP returns if there is no error... You may put an IF around it to check for 0 and return "Not Available"... "Raz" wrote: =IFERROR(VLOOKUP($E$2,L:O,4,FALSE), "Not Avialable") hi, I am using this (above) equation, to do lookups from 5 columns. the lookup thing is working but when there is nothing in the cell (that the function looking up) it returns 0 instead of "Not Available" (as in the equation). i want the function to show "Not available" when the cell is blank, or there is an error. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |