Hi,
The below code works when looking up 2 criteria and then copying and pasting corresponding row in column A to cell G1 (see Sheet1 on the attached file).
A B C D
1/1/2019 Y Yes 1
1/2/2019 Y Yes 1
1/3/2019 N No 2
1/4/2019 Y Yes 1
1/5/2019 Y Yes 1
I would very much appreciate if someone could help me figure out how to do the same thing with the above code but with following 2 scenarios (see Sheet2 on the attached file):Please Login or Register to view this content.
1. copy corresponding row in columns A thru C to cell G1.
2. What if the 2 criteria were in multiple rows (ex. rows 3 and 5)
Thank you so much!!!
Bookmarks