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...
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.