Formula for look up in another sheet?

H

Hall

I can't figure out which function/formula to use.

sheet1!A1 has a reference that gives a value of sheet2.
sheet2!B1 has a text value "happy camper"

I want sheet1!A2 to have a formula that gets the sheet name from sheet1!A1
(so "sheet2") and retrieves the value in cell B1 of that sheet, ie, "happy
camper". So the result is sheet1!A2 shows a value of "happy camper".

Easy, right? What's the formula for that?

Thx!
 
P

Peo Sjoblom

=INDIRECT("'"&A1&"'!B1")

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

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

Similar Threads

I am looking for a formula which extracts a list from data in sheet1to sheet2 filtered by a starting 1
Duplicating cell values from one sheet to another 3
how ro reference to other sheet with look 1
Excel formula referencing cells 4
Fill 1
How to Copy data from a row to a column 3
look to a cell for a reference to a sheet 2
Copy cell formula returns zero instead of cell value 1

Top