using cell contents to link to other tabs
need equation / function that combines the contents of two or more cells to
determine the name of the tab of which to extract the contents from |
using cell contents to link to other tabs
As I replied in other group you multi-posted to.............more details,
but INDIRECT function is what you need. Gord Dibben MS Excel MVP On Tue, 2 Jun 2009 16:06:01 -0700, CLGonline wrote: need equation / function that combines the contents of two or more cells to determine the name of the tab of which to extract the contents from |
using cell contents to link to other tabs
Hi,
to combine the two or more cells use the & sign or CONCATENATE function. Combine this with the INDIRECT function. For example if you want to retrieve the data in cell A5 of the January Sales sheet and January in in A1 of a different sheet and Sales is in B1 of that sheet your formula would be: =INDIRECT("'"&A1&" "&B1&"'!A5") -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CLGonline" wrote: need equation / function that combines the contents of two or more cells to determine the name of the tab of which to extract the contents from |
All times are GMT +1. The time now is 05:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com