apsblackhorse
New Member
- Joined
- Jul 28, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi everyone, I was wondering how to do a lookup value using multiple criteria.
Scenario: I have 2 sheet tabs; one is for data entry and other is for overview (like a pivot table view). Whatever I enter on the "data entry tab" will show on a formatted overview tab. On overview, I have this XLOOKUP code that returns #N/A and I couldn't figure out what I have missed. Please find attached sheet. Thanks for the assistance in advance.
Overview Tab
Data Entry Tab
Scenario: I have 2 sheet tabs; one is for data entry and other is for overview (like a pivot table view). Whatever I enter on the "data entry tab" will show on a formatted overview tab. On overview, I have this XLOOKUP code that returns #N/A and I couldn't figure out what I have missed. Please find attached sheet. Thanks for the assistance in advance.
VBA Code:
=IFNA(XLOOKUP(Overview!$A$4,'Data Entry'!C6,XLOOKUP(Overview!$D$1,'Data Entry'!B6,'Data Entry'!A6))," ")Overview Tab
Data Entry Tab
