2 way lookup using XLOOKUP function in Excel

2 way lookup using XLOOKUP function in Excel.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick

[erniewhite]

This is post had a bonus in it. I did not realize you could move the pop-up hint around

[suruthyvishwa]

Easy to Understand, Wonderful way of teach. Thank you bro.

[nadanavinayagan]

One of the finest method of XLOOKUP. great man.

[christopherwilmes]

Dude this helped me so much! Thank you!

[pratikrocks]

Ajay...good...please make a video on scenario manager, goal seek, data table

[sawans_info]

Index and Mach formula bhi laga sakte hai

[wasiqulislam]

If I'm not wrong xlookup was introduced in office 365. For older versions, can it done with vlookup?

[woodox]

Whats the difference of this compare to vlook up tutorial?? The purpose looks same

[mohamedfarahabdullahi]

Please share a PDF in the description of the video.

[azhadshamim]

Good morning
Hi sir,
How to use xlookup to get value from sheet1 to sheet2 even from 1 file to another file
Plz video

[gurupradeep]

Instead of just read out the formulae, if you could just elaborate about why we need to use the formulae that would be more helpful

[mrcmdnabeel]

Please send the xlookup function add in set up file

[mdafroze]

=xlookup("tony", name_column, computer_column, "not avilable, 0) this will also work i guess

[TVStar]

Wow impressed, can you find my marks as well - Anita

[zafarvlog]

Same result by vlookup and match function is also possible

[arnowisp]

Using Excel is not that different fro. Programming.

[zafarvlog]

=VLOOKUP(E15, C4:G13, MATCH(E16, D3:G3, 0)+1, 0)