Channel: MrExcel.com
Category: Howto & Style
Tags: excelvlookup to match two cellstwo-way lookup in exceltwo-way vlookupmrexceltwo-way xlookup in excelpower query matching on two columnsmicrosoft excelbill jelenvlookup to match two columnsxlookup to match two columnstwo-way lookup in excel with power query
Description: Matching data between two Excel worksheets where you need to match both the city and the tax rate in order to find the match. This video shows three different methods. Table of Contents (0:00) Welcome (1:01) Using XLOOKUP for two-way match (2:15) Using VLOOKUP with concatenated key (3:18) Using three queries in Power Query for two-way lookup