IF, ISNA & VLOOKUP

S

Sara

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,FALSE),0,IF(VLOOKUP(A138,SUMMARY_ADDITIONAL_PAY,9,FALSE)="",0,2.19)))

The message window tells me that the "0" in the ISNA function is causing an
error.

What have I done wrong?
 
T

T. Valko

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))
 
S

Shane Devenshire

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
 
S

Sara

Thanks to both of you.

T. Valko said:
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top