The following formula searches column K of each sheet listed in A2:A4 of the Summary sheet for the value in cell F2 of the Summary sheet, and returns the corresponding value from column L...
=VLOOKUP(F2,INDIRECT("'"&INDEX(A2:A4,MATCH(TRUE,COUNTIF(INDIRECT("'"&A2:A4&"'!K:K"),F2)>0,0))&"'!K:R"),2,0)
How could this formula be adjusted to return the corresponding value from column B (a column to the left of K) instead of column L (a column to the right of K)?
=VLOOKUP(F2,INDIRECT("'"&INDEX(A2:A4,MATCH(TRUE,COUNTIF(INDIRECT("'"&A2:A4&"'!K:K"),F2)>0,0))&"'!K:R"),2,0)
How could this formula be adjusted to return the corresponding value from column B (a column to the left of K) instead of column L (a column to the right of K)?
Last edited:
