VLOOKUP, MATCH & INDEX
Install Add-ons: Formiraex You will learn about How to use the VLOOKUP, MATCH & INDEX functions. Use VLOOKUP to search and get the desired value from the range of data.example:=VLOOKUP(I3, D3:G6, 4, FALSE)* I3 is the lookup value.* D3:G6 is the Table array of data searched.* 4 is the column number of the returned data from Table array.* TRUE/FALSE is the logic.TRUE = Approximate matchFALSE