Index Match
 

Hi All,

can anyone help me with the following:

These are cells A1 - E5

qwert
asdfg
z1234
c6759

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

Thanks

Mike

Index Match
 

Hi,

I think this needs a little more clarification. Why does e,f,c=5 ?

Mike

"Mike B" wrote:

Hi All,

can anyone help me with the following:

These are cells A1 - E5

qwert
asdfg
z1234
c6759

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

Thanks

Mike

Index Match
 

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

Index Match
 

Can you explain why that results in 5?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike B" wrote in message
...
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