Timeline for Google spreadsheet lookup
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 21, 2015 at 21:58 | answer | added | user79865 | timeline score: 1 | |
| Oct 21, 2015 at 21:52 | comment | added | Jeff Cook | 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) | |
| Oct 21, 2015 at 1:09 | comment | added | user79865 |
=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?
|
|
| S Oct 20, 2015 at 23:38 | history | suggested | SightSpirit | CC BY-SA 3.0 |
Polished for readability
|
| Oct 20, 2015 at 20:52 | review | Suggested edits | |||
| S Oct 20, 2015 at 23:38 | |||||
| Oct 20, 2015 at 20:25 | review | First posts | |||
| Oct 20, 2015 at 23:41 | |||||
| Oct 20, 2015 at 20:21 | history | asked | Jeff Cook | CC BY-SA 3.0 |