Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP using multiple data sources
Hi Everyone,
Before I ask the question let me start by wishing everyone a happy festive season. Now for the hard work :-).... I am creating a document that requires the VLOOKUP formula to check multiple sheets to return the desired result. I'm going to try and give a basic layout of what I am looking for. Sheet 1 - Results Sheet (Workbook A) Sheet 2 - Data Sheet from a different workbook (Lets call it Workbook X) Sheet 3 - Data Sheet from a different workbook (Also Workbook X) Sheet 4 - Data Sheet from a different workbook (Also Workbook X) Workbook A contains all staff list of all staff within the business across all departments on one worksheet. Workbook X contains all staff within the business seperated onto different sheets per department. Each sheet has the staff memebers name in column 1, and then has a column for each week of the year. I would like Workbook A to perform a VLOOKUP (Or whichever formula would be best suited) to look to Workbook X and return the scores from the various weeks onto one sheet in Workbook A. I hope that this explination makes sense as it is rather difficult to explain what I am trying to achieve. |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup function across data copied from various sources | Excel Worksheet Functions | |||
Spreadsheet With Multiple Data Sources | Excel Worksheet Functions | |||
Pivot table - multiple data sources | Excel Discussion (Misc queries) | |||
filter data from multiple sources | Excel Discussion (Misc queries) | |||
Data Validation with Multiple Sources | Excel Discussion (Misc queries) |