Forum Discussion
Tab Referencing
Hi gang! I'm sure this is covered somewhere but I'm not able to find. A row of cells in tab "ORDERS" contain complicated part numbers (e.g., 123A567B9). I break out each part number in neighbor...
It sounds like you're a relatively sophisticated Excel user who may just need to be pointed to the appropriate function. Let's try that. Check out INDIRECT. I think that it , in conjunction with VLOOKUP to get the tab's name, may well be what you need to create a direct reference to the appropriate cell on the SUPPLIER sheet (and others, as needed).
Here's a great reference to INDIRECT. If this isn't sufficient (i.e., if you need further help), please come back with a copy of your workbook (or a mock-up that removes any confidential data), so that we can give specific and directed help.
https://exceljet.net/excel-functions/excel-indirect-function