Two Parameters for Lookup or Match

[djveed]

Hi gang. I'm trying to pull from a tab in which Column A is a year, and Column B is a company name. How do I tell it to find the row corresponding to BOTH "IBM Inc" and "2017", and then return the value from the 10th column?

 

[Nine Zero]

Try this out,

=INDEX(J1:J8,MATCH(E12&F12,A1:A8&B1:B8,0))

if you are hard coding these then the formula would change to this

=INDEX(J1:J8,MATCH("IBM Inc"&"2017",A1:A8&B1:B8,0))

Change the red text to where ever your two search values are located or simply type them in if you are hard coding them. Also change the ranges of all columns to the desired ones. And lastly this is an array formula, so when typing it into the formula bar, be sure to press CTRL + SHIFT + ENTER instead of just ENTER

 

[djveed]

Thanks. This actually isn't working. Is it because I have multiple instances of each point of data (i.e. multiple cells say 2017 in column A, and multiple cells say IBM in column B, but only one row says BOTH). What do you think I'm doing wrong?

 

[djveed]

Let me show you the formula I'm trying to use:

{=MATCH($B7&$B$2,QER!$A:$A&QER!$B:$B,0)}

Where B7 is referring to a company name, B2 is referring to a cell which says 2017. And QER is the name of a tab, where column A in the tab are years, and column B are company names.

 

[djveed]

Okay.... they were backwards. My "&" had them switched. I know that now. I now realize my mistake. yes, now I do. I shall now correct it.

Thank you @NineZero.