PDA

View Full Version : Solved: Problem with INDEX , MATCH



Pizzafiend
01-11-2006, 01:13 PM
Greetings everyone,
For some reason I have an index match formula using named ranges that will not match correctly. I have attached a sample of the problem. Any help would be greatly appreciated. I use the same formula referencing a different sheet and it works fine.

austenr
01-11-2006, 02:59 PM
MATCH needs a 1Xm table (that is, a horizontal or vertical reference) not a named range

Shazam
01-11-2006, 05:01 PM
You can use a non-array formula.