T
Tami
if i have a vlookup and it doesn't find a match and the data is not sorted in
ascending order, how do i get it to return a 0 instead of N/A or the closest
value?
assume somthing simple like: =VLOOKUP(A4,Sheet1!A5:C21,3)
ascending order, how do i get it to return a 0 instead of N/A or the closest
value?
assume somthing simple like: =VLOOKUP(A4,Sheet1!A5:C21,3)