1

I need to lookup cell values on multiple sheets (tabs in current sheet) and generate a simple report on a sheet/tab named "REPORT" of the current Google Sheet.

Sheetname1 Lookup column A for X, provide corresponding value in column B on those rows

Sheetname(N) Lookup column A for X, provide corresponding value in column B on those rows

Simple enough, I know, but I am a novice at Google Sheets functions, and it would take me days to figure it out from other sample formulas...

  • 2
    =vlookup(X, Sheetname1!A:B, 2, false) does what you want, except it's not clear why you say "rows" in plural (and "value" in singular). Can you clarify whether multiple rows of those sheets might be matching X, and if so, what do you want to happen in that case? – user79865 Oct 21 '15 at 1:09
  • Multiple rows of those sheets might be matching X. If so, they should be listed one row after the other. Sheetname[1] (line break), matching result 1 (line break), matching result[n] (line break) and Sheetname[n], matching result 1 (line break), matching result[n] (line break) – Jeff Cook Oct 21 '15 at 21:52
1

You can use either filter or query for this.

=filter(Sheetname1!B:B, A:A = X) 

or

=query(Sheetname1!A:B, "select B where A = X") 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.