VloopUp or Index

[kcroft88]

Hi,

I am creating a Index/Match formula that requires certain criteria to be met. I have tried both index and match as well as a vlookup but what I have keeps returning #Ref error.

A screenshot of my sheet is here: http://tinypic.com/r/ncha0x/9

Basically I want the formula in the yellow box and want it to match criteria of Product 1,2,3 or 4 & Month.

Any helps is greatly received, Thanks

 

[wideboydixon]

Re: VloopUp or Index help

M84 formula:

=INDEX($G$10:$AI$13,MATCH(M83,$B$10:$B$13,0),MATCH(L84,$G$9:$AI$9,0))

Untested as I'm only working on a screenshot but you should be able to copy that to P84, T84 and W84 as necessary.

WBD