Vlookup Formula

[rizmomin]

Hello:

Please refer to attached sheet.
I would select the month and store from dropdown list in cell A2 and A3

I need the formula in cell C5 to populate the value from data C1:H13.

Manually i have entered the value as you can see.

Please let me know if you have any questions.

Thanks

Riz

[RS15]

Just put this in A5:

Please Login or Register  to view this content.

-If you found this helpful, feel free to express thanks with the star in the bottom left.

[FDibbins]

If you are going to be copying this formula anywhere, you need some additional absoluting onthe D/D references...

=INDEX($C$1:$H$13,MATCH($A$2,$C$1:$C$13,0),MATCH($A$3,$C$1:$H$1,0))

[rizmomin]

Hi RS15:

Thanks a lot...this will work for me..

Riz