I am in the process of creating a file using a few different lookups and I'm running into some problems. I am looking to use a function in order to perform a lookup and return exact matches only, but I can't use VLOOKUP (which I know allows you to find exact matches only by stating FALSE at the end) since I have already used it in a different part of this sheet (can't change the order of the columns since the leftmost column is being used by this VLOOKUP).
Is there a way to use the LOOKUP function but have it only return exact matches? I was thinking I could use some kind of IF function but I'm having trouble coming up with a solution.
Bookmarks