We can lookup in Excel with two criterias or commonly called a two way lookup.
A Nested Xlookup is one possible solution which can make your choice of criteria dynamic.
**********************************************
If you company is looking for an Excel or Power BI Online and Live courses please visit
https://pivotviz.com/private-group-tr...
Email: [email protected]
**********************************************
excel | tagalog | powerbi | dashboarding in excel | dynamic array | xlookup