Nested vlookup
 

My formula is:

=((VLOOKUP($W$5181,Download!$A$1:$X$3403,3,FALSE)) +(VLOOKUP($W$5182,Download!$A$1:$X$3403,3,FALSE))) *0.001

The formula looks up the value in "$W..."and returns the amount of orders.
I alwayshave values for the first part of the lookup, but niot the second.

THe issue is that if there nothing to report back for the second lookup, it
gives me an "#NA" errror instead of at least returning the value for the
first lookup.

Any help?

Thanks,
TJ

Wrap both Lookups in their own ISNA() wrapper to trap for that error:-

=(IF(ISNA(VLookup1),0,VLookup1)+IF(ISNA(VLookup2), 0,VLookup2))*0.001

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"tojo107" wrote in message
...
My formula is:

=((VLOOKUP($W$5181,Download!$A$1:$X$3403,3,FALSE)) +(VLOOKUP($W$5182,Download!$A$1:$X$3403,3,FALSE))) *0.001

The formula looks up the value in "$W..."and returns the amount of
orders.
I alwayshave values for the first part of the lookup, but niot the second.

THe issue is that if there nothing to report back for the second lookup,
it
gives me an "#NA" errror instead of at least returning the value for the
first lookup.

Any help?

Thanks,
TJ