VLOOKUP into multiple worksheets based on cell values.

Tomo1971

New Member
Joined
May 20, 2015
Messages
6
Hi, looking for some help - I am at a basic level at excel, have to use the formula wizards for vlookups and generally use google to find an answer and use trial and error to find a solution. To this question though, cant find anything,

We run a team of engineers that work over several projects in the week but we want to send one excel schedule out to them.

Each project uses their own excel project tracker and has their own information that needs entering on the schedule.

Each site they visit has a 5 digit unique code - the site reference. We want to extract, from different project trackers, the address / postcode etc for each engineer and day.

If it was just one project, simple VLOOKUP would suffice - we enter a site number and the VLOOKUP goes and fetches that info from the source. Is that attainable if we have several sources by using the same formula in each Day?

We could obviously enter on the schedule the site number and the project name (ie, 12345 & Project_Alpha)

So we would have multiple project trackers with the below info in them, probably different columns and want to transfer it into a schedule based on site number and project name

ABCD
1Site RefAddressPostcode
21234525, High StreetKW1 1QL
3678908, Low StreetST2 8PR

<tbody>
</tbody>

Can this be done?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
You could use an indirect formula to pull data from different sheets but I think you would need a common source folder for the Engineers Workbooks.

Lets say for example that 10 engineers were saving their own sheets to one cloud folder such as Dropbox or google docs, then the file path source of the different sheets would be the same but just different Sheet names. Then you could just have a table on your schedule sheet that has the site number and workbook file name which the formula would use to lookup/extract your data.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,085
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top