Find values on another sheet
 

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

Find values on another sheet
 

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

Find values on another sheet
 

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" wrote:

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

Find values on another sheet
 

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




--


Regards,


Peo Sjoblom



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

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

Find values on another sheet
 

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

"Peo Sjoblom" wrote:

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




--


Regards,


Peo Sjoblom



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

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

Find values on another sheet
 

You're welcome


--


Regards,


Peo Sjoblom



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

"Peo Sjoblom" wrote:

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




--


Regards,


Peo Sjoblom



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

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