Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Mike | 54 | ||
2 | ||||
3 | Sheet2 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0) |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Alex | 91 | ||
2 | Adriana | 40 | ||
3 | John | 84 | ||
4 | Diana | 25 | ||
5 | Mike | 54 | ||
Sheet2 |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | James | 79 | ||
2 | Robert | 76 | ||
3 | Patricia | 94 | ||
4 | Mary | 18 | ||
5 | Thomas | 91 | ||
Sheet3 |
I have and Excel file with 3 spreadsheets.
In Sheet1, in VLOOKUP formula (cell B1), instead of modifying the name of the sheet into the formula, is it possible to link cell A3 with cell B1?
So instead of { =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,0) } to have something like { =VLOOKUP(A1,A3!$A$1:$B$5,2,0) } ?
I would basically like to input data only in cells A1 and A3 and cell B1 to update automatically.
I'm not sure if I made myself clear...