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...
Carl_W Combining INDIRECT, as suggested by mathetes , with the ADDRESS function can achieve what you need. In the attached workbook, I've mocked-up something that demonstrates how this could work. So, S, 3, B will pick up the value from SUPPLIER!$B$3
