ExcelBanter - Multiple Variable Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple Variable Formula (https://www.excelbanter.com/excel-discussion-misc-queries/157640-multiple-variable-formula.html)

Multiple Variable Formula

At the top of my spreadsheet I have the following setup:
A B C D E
1 Bob Don Mark Sam
2 Mon 8 6 5 9
3 Tues 5 4 7 8
4 Wed 3 3 4 5
5 Thur 7 5 6 7
6 Fri 6 5 9 7

Lower in the spreadsheet I have a row (26) which includes names which are
listed in Row1. Column M lists days of the week just like Column A above.
What formula can I use to search the above data to return a value based on
the name and day of week shown. For example, if cell 26N = "Mark" and cell
28M = "Thur" then I would like cell 28N to have a value of 6.

--
Ken

Multiple Variable Formula

=INDEX(A1:E6,MATCH(M28,A1:A6,0),MATCH(N26,A1:E1,0) )

"Ken" wrote:

At the top of my spreadsheet I have the following setup:
A B C D E
1 Bob Don Mark Sam
2 Mon 8 6 5 9
3 Tues 5 4 7 8
4 Wed 3 3 4 5
5 Thur 7 5 6 7
6 Fri 6 5 9 7

Lower in the spreadsheet I have a row (26) which includes names which are
listed in Row1. Column M lists days of the week just like Column A above.
What formula can I use to search the above data to return a value based on
the name and day of week shown. For example, if cell 26N = "Mark" and cell
28M = "Thur" then I would like cell 28N to have a value of 6.

--
Ken