DEFINITION:- In Normal Vlookup We Lookup By Providing The Lookup Value (Row) In First Parameter And We Have A Column Index Number Fixed. But With The Help Of Match Function We Can Create A Dynamic Index Number And Can Actually Lookup By Row And Column Together.
Match :- Match Function Provide The Position Of The Given Criteria. So As Per This Example Our English Subject Is Residing In Column 3 According To Our Table Range. So Now If We Lookup English With The Help Of Match Function It Will Return The Position Of English Subject And That Is On 3rd Position. So Our Index Number Will Be 3 .So Now If We Change The Subject Our Index Number For Vlookup Will Also Get Changed.
NOTE:- Column For Match Function Must Match To The V-lookup Range Other Wise It Will Give Error.