Hi there,
hope someone can help here -
=IF(VLOOKUP(A5,$B$2:$U$1000,18,FALSE),VLOOKUP(A5,$B$2:$U$1000,18,FALSE),VLOOKUP(A5,$B$2:$U$1000,19,FALSE))
I have used the above formula to find the answer. If column both column 18 and 19 has no number, then = N/A but i dont want to equal to N/A, i wanted to equal to 0.
Thanks
Sandy
Bookmarks