Forum Discussion
Array Formula
I'm trying to pull information from a different sheet as long as the name and the date is the same I want to pull specific data from one cell. I'm struggling to come up with the formula to make it h...
If the names of your sheet are in a specific order you can write an INDIRECT function to create address from string to define the name of the sheet to read data and then INDEX-MATCH-VLOOKUP formulas to get the data you need.