Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how can I do a VLOOKUP with two criteria from two different excel sheets? Please see below. I need to VLOOKUP the information to Data
how can I do a VLOOKUP with two criteria from two different excel sheets?
Please see below.
I need to VLOOKUP the information to Data Sheet 1 from Data Sheet 2 (Description) only if Client ID Num and Date match.
Data Sheet 1 | Data Sheet 2 | |||||||
Client ID Num | Date | Product | Description | Client ID Num | Date | Description | ||
522 | 1/2/2020 | lab1 | 522 | 1/1/2020 | Red | |||
522 | 1/3/2020 | lab2 | 522 | 1/3/2020 | Blue | |||
522 | 1/4/2020 | lab3 | 522 | 1/3/2020 | Black |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started