Try

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


--


Regards,


Peo Sjoblom


"Joe Gieder" wrote in message
...
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