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?
|