สูตร INDEX & MATCH ตอนที่ 2

The Index-Match Function in Excel is a method to retrieve data from a selected range of cells

INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups This is because INDEX and MATCH are incredibly flexible

set index ย้อนหลัง The term Match is self-explanatory The Match function in Excel is dedicatedly designed to search for a given term, part, or text in a range

โต๊ะทํางาน index Go to Tools -> Add-Ins ; Make sure Analysis ToolPak and Analysis ToolPak - VBA add-ins are both checked 10, INDEX MATCH