Doubt regarding Ques 3 and Ques 4 of Session 6 of Excel MasterClass

3 Return the position of Rachana Aggarwal (Use Cell B21 as reference) in the above table using INDEX Employee Name Position Rachana Aggarwal 4 Return the name of the employee using HLOOKUP based on position 4 (Use Cell B26 as reference) Position 4 Employee Name ` In the above formula if you give the table_array as A1:G11, you get incorrect result but get the correct result when you use A1:B11. Why?