I have a formula:
When used in a spreadsheet like below:
when put in column B, it will provide the age of the person referenced in Column A.
This works fine, but I have encountered a need to expand the formula where I'd like to reference more than just 1 cell.
So for instance in the code:
I would like to not just reference A1 but other cells as well. How would I go about adding additional cells to reference in this formula?
Excel Formula:
=INDEX($D$1:$D$6,MATCH(A1,$C$1:$C6,0))
When used in a spreadsheet like below:
A | B | C | D |
Bob | =INDEX($D$1:$D$6,MATCH(A1,$C$1:$C6,0)) | Susan | 25 |
Susan | =INDEX($D$1:$D$6,MATCH(A2,$C$1:$C7,0)) | Bob | 45 |
Bill | =INDEX($D$1:$D$6,MATCH(A3,$C$1:$C8,0)) | Jason | 78 |
Ashley | 39 | ||
Bill | 19 | ||
Cindy | 27 |
when put in column B, it will provide the age of the person referenced in Column A.
This works fine, but I have encountered a need to expand the formula where I'd like to reference more than just 1 cell.
So for instance in the code:
Excel Formula:
=INDEX($D$1:$D$6,MATCH(A1,$C$1:$C6,0))