MATCH() searching in a list of numbers
Posted by Chris II on March 23, 2001 10:40 AM
I have a column with a list of catalog numbers and a corresponding column with the item's name. I am using INDEX(MATCH()) to look in the column of catalog numbers and return the item's name. The problem I am having is when the catalog number is all numbers and no letters, MATCH() will not find it. WHY!?! The formula I'm using works with all other entries but those will all numbers. I'm looking for an alternative method or an error I may have in my formula.
-Catalog numbers are not in the far left column and cannot be, so cannot use VLOOKUP().
-Have headings for the columns.
-Have named the cell ranges, but also tried defining the range instead of using the named range (didn't work).
-Information is being copied within the same worksheet.
Formula I'm Using:
EEIC_TITLE = named range of the column containing the catalog item names
N2 = cell that contains the catalog item number to lookup
EEIC_CODE = named range of the column containing the catalog numbers