How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?
I have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the project within that sheet. I'm creating a supplier sheet per project which shows all this information, so a straightforward VLOOKUP works just fine, but a problem arises when a single supplier is working on multiple projects (i.e. I have to reference info from multiple sheets). What is the best way to go about automatically showing this information in the database sheet per supplier?
Any help/suggestions would be very much appreciated!