How can I do a lookup to a specific cell on another tab

K

KevinM

I am trying to create a formula to say go to cell "A3" in sheet 2 and
return what ever the value is in A3. Example if in sheet 2, cell A3
had the value of 100, i would like to create a lookup on sheet one
where i can type in A3 and it would return with the value of 100
 
Z

zvkmpw

I am trying to create a formula to say go to cell "A3" in sheet 2 and
return what ever the value is in A3.  Example if in sheet 2, cell A3
had the value of 100, i would like to create a lookup on sheet one
where i can type in A3 and it would return with the value of 100

One way is to put
A3
(or another cell address) in Sheet1!A2 and put this in Sheet1!A1:
=IF(INDIRECT("Sheet2!"&A2)="","",INDIRECT("Sheet2!"&A2))

The purpose of the IF(...) is so you don't get zeros for cells in
Sheet2 that are empty.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top