How to return the value of a cell based on two colums match criter
 

Arrrggghhh

I'm tearing my hair out with this one.

I need to create a formula that will look up the data from 2 seperate cells
in 2 colums and return the corresponding value in the 3rd colum.

Can anyone help?

How to return the value of a cell based on two colums match criter
 

Insert a helper column in which you cancatenate the two keys. Concatenate
the search arguments too.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"yimmin" wrote in message
...
Arrrggghhh

I'm tearing my hair out with this one.

I need to create a formula that will look up the data from 2 seperate
cells
in 2 colums and return the corresponding value in the 3rd colum.

Can anyone help?

How to return the value of a cell based on two colums match criter
 

Hi,

This assumes the criteria are in columns A & B and you want to return column C
The lookup values are in D1 & E1

=INDEX(C1:C20,MATCH(1,(A1:A20=D1)*(B1:B20=E1),0))

'This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.


MIke

"yimmin" wrote:

Arrrggghhh

I'm tearing my hair out with this one.

I need to create a formula that will look up the data from 2 seperate cells
in 2 colums and return the corresponding value in the 3rd colum.

Can anyone help?