Index/Match not working
The range you use to search on the second MATCH will always give you #N/A, as
it using a range with more than one column/row. Can you use one single
column there, like $H$4:$H$25000 or $A$4:$Z4?
Hope this helps,
Miguel.
"frosterrj" wrote:
THis is driving me crazy! The formula below:
=INDEX(Item,MATCH($D7,'Item 5.17.06'!$A$4:$A$25000,0),MATCH($U7,'Item
5.17.06'!$A$3:$O$25000,0)) keeps returning #N/A no matter what I do. Using
array formulas does not help.
I'm trying to find the intersection of the Item number (cell D) and Zone
price (cell U) zones are in columns H to O in the Item array.
My "Item" named range includes the column headers (where the zone numbers
are). I tried replacin the named range with the actual sheet/column
references, but still doesn't work.
Any help appreciated, even if there;s a better function combination that is
not as flaky as the Index/Match combo seems to be.
Thanks,
Robert
|