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