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.
<tbody>
</tbody>
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: