Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two colums match return text from another | Excel Discussion (Misc queries) | |||
Trying to use INDEX and MATCH to insert a value w/ multiple criter | Excel Worksheet Functions | |||
MATCH 3 COLUMS RETURN 4TH | Excel Discussion (Misc queries) | |||
MATCH 3 COLUMS RETURN 4TH | Excel Discussion (Misc queries) | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions |