Excel find corresponding value, return `0` if not found

Question

I have the formula:

=LOOKUP(C2,'Jul-14'!A:A,'Jul-14'!B:B)

Where:

• C2 = "Aruba (AW)"

The sheet "Jul-14" doesn't contain the value "Aruba (AW)" in column A. When this happens, it seems to take the closet match and return the value in column B. I need it to return 0 if no exact match is found, or the B column value if an exact match is found.

I've tried changing the function to VLOOKUP and HLOOKUP but it doesn't ever return any value.

Answer 1

The following should lookup the value in C2 against the values on the sheet in column A, if it finds a match then it will show it, if it doesn't then it will throw an error which will then return 0

=iferror(vlookup(C2,'Jul-14'!A:B,2,False),0)