“=VLOOKUP(C2,INDIRECT("'"&INDEX(A2:A4,MATCH(TRUE, COUNTIF(INDIRECT("'"&A2:A4&"'!G2:G5"),C2)>0,0))&"'!G2:H5"),2,0)”Tagged: Excel