สอนใช้ INDEX + MATCH แบบสั้นๆ เท่าที่จำเป็น

The MATCH part of the formula combines the lookup value as well as the entire lookup array When $A$2:A11&””&$B$2:$B$11 is used

The INDEX MATCH in Excel function is used to search tables from left to right Unlike VLOOKUP, INDEX MATCH lets you return a result from a

match made in heaven by chance INDEX MATCH simplifies finding the data you need, especially if you have multiple sheets that you need to pull the data from in Excel or Google Sheets

fuku matcha สาขา Best Answers If you would prefer blank to #NO MATCH you could add an IFERROR statement to the formula If you want to return blank instead