I'm having issues with the last part of my formula. I have two sheets, a results page (where the formula is written) and the Database page where all results will be stored. When I write this formula out on the database page, it works exactly how I want it to, just need it to work on my results page with reference to the Database sheet
{=INDEX(INDIRECT("'Database'!$F$2"),SMALL(IF(Database!$A$3:$A$999=$G$5,ROW(Database!$A$3:$A$999)-ROW(Database!$A$3)+1),1))}
The return should be INDEX(DataBase!$F$3:$F$999,1) but I cant seem to get (INDIRECT("'Database'!$F$2") to work properly and I feel dumb
Row 2 on the database page is my helper column which returns the array I am searching, which works fine:
=SUBSTITUTE(ADDRESS(1,MATCH(F1,1:1,0),4),1,"")&"3"&":"&SUBSTITUTE(ADDRESS(1,MATCH(F1,1:1,0),4),1,"")&"999"
Thanks in advance!
{=INDEX(INDIRECT("'Database'!$F$2"),SMALL(IF(Database!$A$3:$A$999=$G$5,ROW(Database!$A$3:$A$999)-ROW(Database!$A$3)+1),1))}
The return should be INDEX(DataBase!$F$3:$F$999,1) but I cant seem to get (INDIRECT("'Database'!$F$2") to work properly and I feel dumb
Row 2 on the database page is my helper column which returns the array I am searching, which works fine:
Thanks in advance!
Last edited: