Use Multiple criteria in and Xlookup formula. A 2 way Xlookup function contains both Vlookup and Hlookup functions in one easy to use formula.
Other playlists:
PIVOT TABLES:
• Excel pivot table dates to Months - Pivot ...
EVERYTHING about the FILTER FUNCTION:
• EXCEL Filter Rows & Columns
EXTRACT first word, 2nd word, last word, numbers, letters:
• Extract the numbers from a Cell in Excel -...
2 MINUTE Formula:
• Excel If formula - If CONTAINS formula in ...