| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, ISNA & VLOOKUP
Hi there,
I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, ISNA & VLOOKUP
Nevermind - lacking coffee and an extra bracket
"Sara" wrote: Hi there, I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, ISNA & VLOOKUP
You just have some closing ")" in the wrong place. Try it like this:
=IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)) ,0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)="", 0,2.19)) -- Biff Microsoft Excel MVP "Sara" wrote in message ... Hi there, I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, ISNA & VLOOKUP
Hi,
Just an FYI - if you are using 2007 then =IFERROR(IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9, FALSE)="",0,2.19),0) Cheers, Shane Devenshire "Sara" wrote: Nevermind - lacking coffee and an extra bracket "Sara" wrote: Hi there, I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, ISNA & VLOOKUP
Thanks to both of you.
"T. Valko" wrote: You just have some closing ")" in the wrong place. Try it like this: =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)) ,0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)="", 0,2.19)) -- Biff Microsoft Excel MVP "Sara" wrote in message ... Hi there, I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF, ISNA & VLOOKUP
You're welcome!
-- Biff Microsoft Excel MVP "Sara" wrote in message ... Thanks to both of you. "T. Valko" wrote: You just have some closing ")" in the wrong place. Try it like this: =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)) ,0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,0)="", 0,2.19)) -- Biff Microsoft Excel MVP "Sara" wrote in message ... Hi there, I currently have the following formula =IF(VLOOKUP(A137,SUMMARY_ADDITIONAL_PAY,9,FALSE)=" ",0,2.19) I'm trying to amend this to include; IF (VLOOKUP) = #N/A then make it 0 I had a look at previous posts and I can't get it working. My formula currently is =IF(ISNA(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FAL SE)="",0,2.19))) The message window tells me that the "0" in the ISNA function is causing an error. What have I done wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help with a IF(ISNA with vlookup | Excel Worksheet Functions | |||
| vlookup, IF, and ISNA | Excel Discussion (Misc queries) | |||
| isna vlookup | Excel Discussion (Misc queries) | |||
| ISNA and VLOOKUP | Excel Worksheet Functions | |||
| if isna and vlookup together | Excel Worksheet Functions | |||
Linear Mode
