Find values on another sheet

[Joe Gieder]

Thank you for looking at this and for your help.
Is there a way to use values in two other cells to find a value on another
worksheet within the same workbook?
On the main sheet it has:
A (sheet names) B (cell to look at on other sheet)
2 GE PO 2051280 $G$8
3 GE PO 2051280 $L$8
4 GE PO 2051280 $L$9
5 GE PO 2057879 $B$8
6 GE PO 2057879 $G$8
7 GE PO 2057879 $G$9

I'm trying to get the value that's in cell G8 on sheet GE PO 2051280 (and so
on)
When I use the formula ='A2'!B2 a popup box opens wanting to know what file
to use.

Thanks in advance
Joe

 

[Peo Sjoblom]

Try

=INDIRECT("'"&A2&"'!"&B2)


--


Regards,


Peo Sjoblom

 

[Joe Gieder]

Thank you it works perfectly.
Now is there a way to use this formula to find the value in cell D8 on the
the work sheet in this formula =INDIRECT("'"&A2&"'!"&B2) something like
=INDIRECT("'"&A2&"'!"&B2),COLUMN(+2) looking for the cell value two columns
to the right which would be in D8.

Thank you for the help

 

[Peo Sjoblom]

=OFFSET(INDIRECT("'"&A2&"'!"&B2),,2)




--


Regards,


Peo Sjoblom

 

[Joe Gieder]

Thank you very much it works prefectly. You are are a great help and I am
greateful for your asistance.
Joe

 

[Peo Sjoblom]

You're welcome


--


Regards,


Peo Sjoblom

Thank you very much it works prefectly. You are are a great help and I am
greateful for your asistance.
Joe