How to use 2 criteria in a table or grid to find the required result

Hi,

I am used to using Index and Match functions to find a value and return a value from a column, however in this case I need to match the row value and the column value to return the value in the cell where row and column meet. I have attached a simplified example of what I am hoping to achieve. Any help would be most appreciated.

Many thanks

To make it flexible you can setup dropdown validationlist for both rows and columns and then have the Index and match find the result

that gives a formula like:

in cell K4:

Formula:

Please Login or Register  to view this content.

K2 and K3 are the cell data validation lists to pick column and color the other ranges refer to data area, left column and header row to find the matching record.

see attachment

Thank you really helpful both