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...

Improve this question
2
  • 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
    Commented Oct 21, 2015 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
    Commented Oct 21, 2015 at 21:52

1 Answer 1

Reset to default
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")
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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