GALibra109
New Member
- Joined
- Jul 30, 2018
- Messages
- 4
Hello! Excel semi-newbie here. I need help with a problem I've been tasked to help solve in Excel and it involves figuring out what functions to use to create a formula to pull out the information I need.
Sheet 1 = Candidate Information
This table has 3 columns: Candidate ID, Zip Code and EmpPref
Sheet 2 = Job Order Info
This table also has 3 columns: Job Order ID, Zip Code and EmpPref
I'd like to create a third table that combines the information from the 2 tables. I'd like the third table to have these three columns: Candidate ID, # of Job Order Matches, and Job Order IDs.
I'm having a hard time figuring out how to write a formula (which functions to use) to pull the Job Orders for the correct matching candidates based on Zip Code and EmpPref.
Any help is appreciated!
Thanks!
GALibra109
Sheet 1 = Candidate Information
This table has 3 columns: Candidate ID, Zip Code and EmpPref
Sheet 2 = Job Order Info
This table also has 3 columns: Job Order ID, Zip Code and EmpPref
I'd like to create a third table that combines the information from the 2 tables. I'd like the third table to have these three columns: Candidate ID, # of Job Order Matches, and Job Order IDs.
I'm having a hard time figuring out how to write a formula (which functions to use) to pull the Job Orders for the correct matching candidates based on Zip Code and EmpPref.
Any help is appreciated!
Thanks!
GALibra109