return a value based on column and row headers

[jimmy1981]

Hi,

I am trying to find an easy way that will return the value depending on the column header and the row header.

I have attached an example spreadsheet to make it a bit clearer.

Any help would be massively appreciated as I have been trying everything for weeks now and I’m still no further.

[ajaykgarg]

Please Login or Register  to view this content.

in D2, and copy it down.

see attached.

hth
Ajay

Please Login or Register  to view this content.

[jimmy1981]

I could kiss you.

Cheers.

[ajaykgarg]

You can virtually "kiss" me by adding to my reputation, by clicking scales icon next to my post

[virtualdark]

I have the same problem, but because de 1st line are names... the MATCH comand it's counting the number of letters of that name and not working.
Do you know how I can do it?