Lookup sheet based on cell contents

[rsulliva]

How could I write a formula in a cell that would look up cell's (G7) contents (ie the word "Fuel") then find the corresponding worksheet "Fuel" and pull a fixed cell (C2) of that worksheet. The contents in G7 would be able to be changed to, for example, "Water", "Gas", "Electricity" etc. The formula would then go find the corresponding named worksheet and pull C2 from that worksheet.

Thanks for any advise,

Russell

 

[Aladin Akyurek]

How could I write a formula in a cell that would look up cell's (G7) contents (ie the word "Fuel") then find the corresponding worksheet "Fuel" and pull a fixed cell (C2) of that worksheet. The contents in G7 would be able to be changed to, for example, "Water", "Gas", "Electricity" etc. The formula would then go find the corresponding named worksheet and pull C2 from that worksheet.

Thanks for any advise,

Russell

Try...

=INDIRECT("'"&G7&"'!C2")

 

[Roli001]

This should do it:

=INDIRECT("'"&G7&"'!"&"C2")

 

[rsulliva]

Perfect, thanks to both of you!

 

[Aladin Akyurek]

Perfect, thanks to both of you!

You are welcome. Thanks for providing us feedback.