Lookup

[ChrisLane]

Hi All
I have the following table as an example, Name is column A, Dept Column B & Age Column C. Henry to Lynn in rows 2 to 9. I need a formula that will find the row in the table that matches both the contents of cells E2 and F2, and inserts the Age into G2.

I will appreciate any help I get.

	A	B	C	D	E	F	G
2	Name	Dept	Age		Mary	101	?
3	Henry	501	28
4	Stan	201	19
5	Mary	101	22
6	Larry	301	29
7	Harry	401	21
8	Joe	101	23
9	Lynn	301	30

<tbody>
</tbody>

 

[VBA Geek]

have you tried

=SUMIFS(C3:C9,A3:A9,E2,B3:B9,F2)

 

[ChrisLane]

have you tried

=SUMIFS(C3:C9,A3:A9,E2,B3:B9,F2)

Hi, thanks for the response - I tried it, checking the comparative formats, but get the answer 0?

 

[shobolos]

=INDEX(D3:D9,MATCH(F2&G2,B3:B9&C3:C9,0))

Enter the above formula using Ctrl+Shift+Enter

 

[ChrisLane]

=INDEX(D3:D9,MATCH(F2&G2,B3:B9&C3:C9,0))

Enter the above formula using Ctrl+Shift+Enter

Perfect, thanks very much