sir I wlll be grateful if you can organize an XLOOKUP example of "HOW TO LOCATE BUILDING NAMES WITH STREET NAMES" so that if someone asks me for location of any building in my Colony I don't have to remember the name and location
Hi, thanks for your comments. I think you'd need to set your data in a table first (with building names and associated street names). You could then use XLOOKUP if you have the building name. You could also use the FILTER function which I'll have a video on in a few weeks so keep an eye out!
Subscribe here 🛎:
ruclips.net/channel/UCSMHCVgRSSFV6Z79PpNSxkg
Thanks Greg, very useful tool you've shared.
Thanks for your kind comments!
very useful. after this i will use this feature more frequent than v or h
Thank you for your comments!. XLOOKUP is such a powerful function, I hope it makes you more efficient in Excel!
Thanks for explaining how xlookup replaces older functions. Today, however, it’s time to show how ChatGPT can blow all of this out of the water!
Good point! I'll be talking through unlocking the power of ChatGPT on Excel in my next Video!
You are awesome. Want to learn more from you.
Hey, thanks for you're kind comments. Please don't forget to like like and subscribe!
If we have multiple same lookup names in that column with different sales values, how to get result of all sales values related to him?
Hi, you would need to use the SUMIF function to solve that particular problem
Thank you so much .. can you also help on index match pls
Thanks for comments. Yes, sure I'll put something together on index & match. Keep an eye out!
sir I wlll be grateful if you can organize an XLOOKUP example of "HOW TO LOCATE BUILDING NAMES WITH STREET NAMES" so that if someone asks me for location of any building in my Colony I don't have to remember the name and location
Hi, thanks for your comments. I think you'd need to set your data in a table first (with building names and associated street names). You could then use XLOOKUP if you have the building name. You could also use the FILTER function which I'll have a video on in a few weeks so keep an eye out!
As long as Microsoft did not remove them if we need them
Agreed!
hi. the audio is breakup.
don't forget to fix it
Hi, thanks for your comments. Sorry about the audio, had some challenges with the equipment. Hopefully my next few videos will be better.