MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP QUERY


Posted by ROBERT on November 29, 2000 9:15 PM

WHEN I HAVE COMPLETED A VLOOKUP AND THERE HAS BEEN NO VALUE TO RETURN #N/A APPEARS AND AFFECTS MY TOTALING.. IS THERE A FORMULA I CAN USE TO MAKE #N/A BLANK OR A ZERO VALUE THAT WILL NOT AFFECT MY TOTAL ?

THANKS


Posted by Tom G on November 29, 2000 10:18 PM

Hey Robert
Next time don't use
all Caps

But here a formula i use

=IF(ISERROR(VLOOKUP(L11,BTable,2)),"0",VLOOKUP(L11,BTable,2))

hehe i just learn it today

Enjoy

Tom