Website

How To Search Across Multiple Sheets In Excel

(1 total)

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

Tagged: Excel