Karen Schaefer
asked on
Vlookup different worksheets Excel
I am a bit rusty with Vlookups, I have a workbook contains a few wkshts, I need to create a third sheet that displays the Facility Code (FC), however the original wksht have different data types in the same columns. How do I use vlookup to limit the data to the rows of data where the FC contains the actual FC code,
ABE2
10/28/2015
27-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
6-Nov-15
7-Nov-15
10/27/2015
27-Oct-15
26-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
6-Nov-15
10/26/2015
27-Oct-15
26-Oct-15
25-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
ABE3
10/28/2015
27-Oct-15
28-Oct-15
ABE2
10/28/2015
27-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
6-Nov-15
7-Nov-15
10/27/2015
27-Oct-15
26-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
6-Nov-15
10/26/2015
27-Oct-15
26-Oct-15
25-Oct-15
28-Oct-15
29-Oct-15
3-Nov-15
31-Oct-15
1-Nov-15
4-Nov-15
5-Nov-15
2-Nov-15
30-Oct-15
ABE3
10/28/2015
27-Oct-15
28-Oct-15
can u upload a sample file?
It is unclear what you are trying to do. Please take another crack at stating your question, preferably including a sample file (scrubbed first of any sensitive data).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please close chose another route to resolve issue.