Two way lookup with XLOOKUP

Two-way Excel lookup: To look up a value on the rows as well as columns we generally combined VLOOKUP with the Excel Match function or used the famous INDEX & MATCH functions. We no longer need to use two separate functions to do a two-way lookup. We can use XLOOKUP inside another XLOOKUP to get the job done. The advantage is we just need to know one function well, instead of combining different Excel lookup functions with one another.
Hope you like the video
Do share your comments in the comment section.
Follow me on other platforms:-
Join EXCEL MASTERY COURSE by clicking the following link: