Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
Macro to find matching date and copy values to another sheet | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
How do I use VLOOKUP to find values across more than 1 sheet or Wo | Excel Worksheet Functions |