Summary: In this video, Mr. Raj Singh Sir will teach you how to use the NESTED VLOOKUP Formula. We will here learn how to combine two VLOOKUP together to get the final result.
Formulas: ( watch the video to understand better)
=VLOOKUP(LOOKUPVALUE, TABLEARRAY, COLUMNINDEXNUMBER, RANGELOOKUP)
(Notice: extra number is this formula. Kindly watch the video)
=VLOOKUP(LOOKUPVALUE, TABLEARRAY, COLUMNINDEXNUMBER, RANGELOOKUP)
Now we will merge both LOOKUP into one LOOKUP
=VLOOKUP(VLOOKUP(LOOKUPVALUE, TABLEARRAY, COLUMNINDEXNUMBER, RANGELOOKUP), TABLE ARRAY, COLUMN INDEX NUMBER, RANGELOOKUP)
Conclusion: In this video, you learned how to merge data through NESTEDVLOOKUP.
