# Lookup

#### ChrisLane

##### New Member
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>

Last edited:

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
have you tried

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

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?

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

Enter the above formula using Ctrl+Shift+Enter

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

Enter the above formula using Ctrl+Shift+Enter

Perfect, thanks very much

Replies
1
Views
369
Replies
9
Views
612
Replies
5
Views
512
Replies
3
Views
323
Replies
2
Views
451

1,196,476
Messages
6,015,438
Members
441,895
Latest member
Zululander

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back