There is a couple of things i'm trying to do.
how do I use the vlookup function to return a value, but to do it in a specific cell? I.e, I want to always return the value to cell C1, for example.
for example,
I have 2 sheets.
On Sheet 1:
Cell A1 on sheet 1 has the word 'bob.' Cell B1 on sheet 1 has his age, 29.
On sheet 2:
On cell A1 on sheet 2, I have the word 'bob.' It is hyperlinked to a vlookup formula. If I click on the link, I want it to return '29.' The trick is that I want 29 to be displayed on cell C1.
Ive been looking up online but can't find the correct formula for it.
how do I use the vlookup function to return a value, but to do it in a specific cell? I.e, I want to always return the value to cell C1, for example.
for example,
I have 2 sheets.
On Sheet 1:
Cell A1 on sheet 1 has the word 'bob.' Cell B1 on sheet 1 has his age, 29.
On sheet 2:
On cell A1 on sheet 2, I have the word 'bob.' It is hyperlinked to a vlookup formula. If I click on the link, I want it to return '29.' The trick is that I want 29 to be displayed on cell C1.
Ive been looking up online but can't find the correct formula for it.
Last edited: