Excel tutorials

In the last post we used look-up functions to find a fruit and its amount.

That formula did not take into account miss-spellings or items that dit not exist in the list.

In the search field in C13, we have spelled APPLE wrong. Instead of getting #N/A, we now return “NOT FOUND” instead.

To achieve this we can use the ISNA function.

Modify the formula like this:

=IFNA(IF(VLOOKUP(C13;C4:D10;2;FALSE)=0;”NO”;”YES”);”NOT FOUND”)