Index Match

  • Thread starter Thread starter Mike B
  • Start date Start date
M

Mike B

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with part match 5
Scrabble Value calculation for Welsh words 0
IF formula not working 6
Create an array of separate cells 1
MATCH working but not.... 6
Excel Summarization of indexed column 1
Lookup Across Multiple Rows / Columns 5
How to Use two search criteria in one array. 2

Back
Top