Index, Match with 2 criteria

[JO505]

I am having an issue with the following formula.

It will work with either single creteria but not both. I can't seem to find out why?

Please Login or Register  to view this content.

[/CODE]

Column "B" contains dates and Row "2" contains the meal type 'Meal'.

Jim O

[Pete_UK]

Did you commit the formula using CTRL-Shift-Enter, rather than the usual <Enter> ?

Hope this helps.

Pete