INDEX:MATCH with header title that has spaces?

**ks100** · 01-16-2014, 01:52 PM

Please Login or Register  to view this content.

For whatever reason, Excel will not find that header if the name has spaces in it.

If I change the header title name to "ItemList" it finds it just fine. Unfortunately, I cannot change the header title on incoming spreadsheets.

How do I get it to properly do Index Match when the header title has a space in its name?

**Ron Coderre** · 01-16-2014, 02:11 PM

I'm guessing that if Row_1 contains what *looks like* "Item List"..it really has extra spaces before, after, or in the middle.
Using this formula:
=INDEX(3:3,MATCH("Item List",$1:$1,0))

Select the target cell in Row_1 and type: Item List

Does the formula work after that?