XLOOKUP in Googlesheets | Excel | Five Example
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- bit.ly/vt-goog...
Learn Xlookup in Google sheets and Excel. How to use xlookup with five supercool examples.
XLOOKUP एक्सेल का एक SUPER COOL फंक्शन है जो वैल्यू KO दूसरी टेबल से सर्च करने में काम आता है यह फंक्शन अब गूगल शीट में भी अवेलेबल है इस वीडियो में हम xlookup को 5 एग्जांपल का यूज़ करते हुए लर्न करेंगे
00:10 Introduction
00:48 Eg 1 Xlookup Vertical
02:27 Eg 2 Xlookup with Error Handling
03:34 Eg 3 Xlookup Horizental
05:00 Eg 4 Xlookup Approximate
07:24 Eg 5 Two way Xlookup
Does google sheets have xlookup? Yes, recently Google introduced the #xlookup function in Google sheets. How do I add xlookup in google sheets? You need to simply type the function using =xlookup in any cell and enter the argument for getting the result. Why is xlookup not working in google sheets? It is now working in google sheets What is xlookup vs vlookup? Xlookup is an advanced version of vlookup, Google added more options to it. Xlookup can retrieve values in google sheets from other sheets. Lookup in google sheets using xlookup function Xlookup equivalent in google sheets Xlookup formula in google sheets Xlookup function in google sheet
Google Sheet Course : bit.ly/36bZgQ3
#xlookup #googlesheets #excel
________________________________________________
Tally Prime Course 👉 bit.ly/3pwvNe9
MS Access 👉 bit.ly/37DBHEQ
SAP S4 Hana 👉 bit.ly/37GREtV
WhatsApp Marketing👉 bit.ly/3OxtoLu
---------------------------------------------------------------------------
Hi Sir,
Please provide the data of excel to download in excel or to download in google sheet, so that we can practise watching your videos. it will be helpful if every video has the practise file to download. thanks
Nice sir mai bahut confused tha
So my problem is solved
Because
Mai Chromebook lena chahta hu fir soch rha tha ki ismai data entry hogi ya nhi kyuki sir excel Bina primium ke nhi chalta
❤❤❤❤
Sir thanks 🙏🙏🙏🙏🙏
nice
Nice
Thanku sir for helping us god blss u
Thanks🙏
Nice how can join your classs
video is not helpful because there is not data spreadsheet to download and practise :(