Looking up and reporting values across tabs
I have a spreadsheet with a list of codes on separate tabs, each tab
is named according to its category. On the last tab I have a list containing of ALL the above codes, but not which category the code is in. I want a formula to look at all of the tabs (apart from the final one) and return the category for each code and place it next to the relevant code in the list on the last tab. The end result is that each code in the complete list will have the correct category next to it. Any help appreciated. |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com