Hi,
Sorry missed the relevant info out.
I want to search for a value which matches three criteria using rows 1 & 2
and column 1. ie 'e' from row 1, 'f' from row 2, 'c' from column 1. I have
tried using the Index and Match functions but cant get it to work

"Mike B" wrote:

Hi All,

can anyone help me with the following:

These are cells A1 - E5

qwert
asdfg
z1234
c6759

How would I write a formula to return e,f,c = 5

Thanks

Mike