Forum Discussion
Solved
Formula HELP!!
Hi Everybody. I’m struggling with formula and wonder if you can help. I have 2 spreadsheets. The first one represents a list of payments made on a particular day of the month. The columns are dat...
Mark, you takes the value from 1D array and shall position row in it using two criteria (date and room #), not row and column.
It could be
=IFERROR( INDEX($U$3:$U$19, MATCH(1, INDEX( ($A3=$T$3:$T$18)*(B$1=$S$3:$S$18),0),0 ) ), 0)
INDEX within MATCH generates array of TRUE and FALSE (or 1 and 0) depend on criteria is met or not. Multiplication means AND condition.
Please check in attached.
Here it is
Mark, you takes the value from 1D array and shall position row in it using two criteria (date and room #), not row and column.
It could be
=IFERROR( INDEX($U$3:$U$19, MATCH(1, INDEX( ($A3=$T$3:$T$18)*(B$1=$S$3:$S$18),0),0 ) ), 0)
INDEX within MATCH generates array of TRUE and FALSE (or 1 and 0) depend on criteria is met or not. Multiplication means AND condition.
Please check in attached.
MarkK777 , you are welcome