Forum Discussion
Sara Stults
Oct 23, 2018Copper Contributor
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...
erol sinan zorlu
Oct 24, 2018Iron Contributor
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.