Index match Woes....

[luscious]

Hi All,

SO I am using Index and match to cross reference two value on a chart. For some reason, it keeps returning the wrong value! Please see the attached file. The top section of the excel workbook works; it returns the right value. The section below it does not work, it returns the wrong value...and its coded the exact same way. Please help if you can!

TIA!

[Pete_UK]

You are getting your rows and columns mixed up - try it like this:

=INDEX(_tbl2,MATCH(nozzle,nozzles,0),MATCH(refrig,refriges,0))

Hope this helps.

Pete