Summary: In this video, Mr. Raj Singh Sir will teach you how to use VLOOKUP APPROACH Formula in advance form. We will learn to work on two different sheets with some large data and find the commission.
Process: Select the table from the 1st SHEET > FORMULA TAB > DEFINE NAME (Name the table)
Formula: =VLOOKUP(LOOKUP VALUE, TABLEARRAY, COLUMN INDEX, RANGE LOOKUP)
Conclusion: In this video, you learned how to work on big data with two different sheets using VLOOKUP.