Timeline for Using VLOOKUP with dynamic range array
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 21, 2014 at 3:12 | vote | accept | charliesneath | ||
| Jun 21, 2014 at 3:12 | comment | added | charliesneath |
This is indeed what I was looking for. I didn't realize that you could set the range to span the entirety of both columns with , Sheet2!A:B. Thank you!
|
|
| Jun 19, 2014 at 0:02 | comment | added | eddyparkinson | I mean, =vlookup(A1,Sheet2!A1:A,2,0) is also possible | |
| Jun 18, 2014 at 8:41 | comment | added | eddyparkinson | This is right, you can fine tune with A1:A etc | |
| Jun 16, 2014 at 17:37 | history | answered | pnuts | CC BY-SA 3.0 |