SEARCH FOR VALUE IN MULTIPLE COLUMNS

[meppwc]

I am trying to get this to work.
In cell Z2 of the "Data" worksheet, formula needs to search for value in A2, by searching in the "Table" worksheet columns A and B. If the value is found, map what is in column C. If not found, cell is blank.

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F																				Z
1																										Look up
2	12	23	1		3																					125
3	3	25	2
4	22	125	3
5	6	2	4
6	100	56	5
Sheet2

Cell Formulas
Range	Formula
E2	E2	=FILTER(C2:C6,A2:A6=Z2,FILTER(C2:C6,B2:B6=Z2,""))