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

สูตร INDEX & MATCH ตอนที่ 2 index match Example #1 INDEX MATCH as an Alternative to VLOOKUP We will capture the Location column with the Name column as a reference Step 1: In litmatch The INDEX function used with the MATCH function allows for value searching in an array For example

litmatch 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

โต๊ะทํางาน index วิธีใช้งานสูตร Match+Index ค้นหาข้อมูล The INDEX function returns a value based on a location you enter in the formula while MATCH does the reverse and returns a location based on the