Forum Discussion

Sara Stults's avatar
Sara Stults
Copper Contributor
Oct 23, 2018

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 happen, any advice?

excel
Formulas and Functions

2 Replies

  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Oct 24, 2018
    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.
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 24, 2018
    Use the MATCH function to find the row number where your data is, then use the INDEX function to pull information from the column which contains the correct field.