I'm using a simple Index and Match with the 3rd value set to 0 because I'm looking for an exact match:
I was expecting to get a #NA if no match found; instead I get the value for the last record in the list being indexed. This shouldn't happen if I am using 0 for my value, correct?Please Login or Register to view this content.
I'm using Excel 2003.
Bookmarks