Forum Discussion
xlookup help
can someone help me with how to write this formula? I need the two yellow cells to auto populate when I choose day of week and type.
=INDEX($C$3:$I$7,MATCH($C14&E$13,$A$3:$A$7&$B$3:$B$7,0),MATCH($B14,$C$2:$I$2,0))
Above INDEX and MATCH formula works in my spreadsheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
That worked. Thank you so much.