Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Carl S. Warren, William B. Tayler

16th Edition

0357715225, 9780357715222

More Books

Students also viewed these Accounting questions