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?

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?

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?

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?

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?

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?