Forum Discussion
Pulling data fields from reports (based on date) and compiling them into another tab.
Hello, I have an inspector report that I am trying to pull data from certain fields based on a Ring #. The inspector will fill out the main report page and then the selected fields will record o...
Hello,
instead of an IF command i've tried this formula
=IFERROR(INDEX(CoverPage!$I$51:$I$53,MATCH([@Ring],CoverPage!$C$51:$C$53,0)),"")
in cell B3 of sheet "Compiled Info" and it seems to return the expected result. The formula is spilled down within the dynamic table. However because of the merged cells in sheet "CoverPage" i find it difficult to help with this task.
=IFERROR(INDEX($C$2:$C$18,MATCH(1,($A$2:$A$18=F2)*($B$2:$B$18=G2),0)),"")Is this similar to what you are looking for? Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
