WHEN USING VLOOKUP.....
I am looking up an item in 2 different tables, however sometimes the
item is not in both tables.
When the one table does not have the item, excel returns a (n/a)
entry.
How do I program it to use a default value of 0 when no record is
found???
=VLOOKUP(A2,WAUKREF!A2:S1000,18,0)
+VLOOKUP(A2,WWREF!$A$2:$S$1000,18,0)
I THOUGHT MAYBE "0" IN THE ARGUMENT, BUT IT IS NOT WORKING.
IT IS BEING USED TO AUTO CALCULATE THE COMBINATION OF THE TWO FEILDS
ANY HELP WOULD BE GREATLY APPRECIATED
--
wii
------------------------------------------------------------------------
wii's Profile:
http://www.excelforum.com/member.php...o&userid=33958
View this thread:
http://www.excelforum.com/showthread...hreadid=537340