XLOOKUP for google sheets is a custom function that comes handy when you want to search for things from a table or range using another row.
बनाने वाली कंपनी:
लिस्टिंग को पिछली बार अपडेट किया गया:8 जनवरी 2022
इनके साथ काम करता है:
16 हज़ार+
अवलोकन
Sample use case is if we want to find employee name based on their employee number. 
With XLOOKUP google sheet function, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
XLOOKUP for google sheets is an improvement on three existing formulas: VLOOKUP and HLOOKUP which have same syntax however with VLOOKUP you can utilise a column number in the lookup table. The downside of the two formulas is that if the table is changed the whole formula breaks. This is something we have solved in xlookup for google sheets. The other formula is INDEX(MATCH): which is a more sophisticated solution for lookups on data on tables however more difficult for most normal users. This again has been simplified by xlookup for google sheets.

Formula one: XLOOKUPTEXT  
This is the xlookup for use in matching based on text similarity. The formula uses fuzzy lookup matching as well allowing for exact match. The function has the following parameters:
lookup_value: The value to search for If omitted, XLOOKUP returns blank cells it finds in the lookup array.
lookup_array: The column to search the lookup value in.
return_array: The column or columns to return once we find a match.
Threshold: The minimum value of text similarity btwn lookup value and lookup array

Formula two: XLOOKUPNUMBERS
This is the xlookup for use in matching numeric based primary keys. The function has the following parameters:
lookup_value: The value to search for If omitted, XLOOKUP returns blank cells it finds in the lookup array.
lookup_array: The column to search the lookup value in.
return_array: The column or columns to return once we find a match.
[if_not_found] Where a valid match is not found, return the [if_not_found] text you supply. If a valid match is not found, and [if_not_found] is missing, #N/A is returned.
[match_mode] 0 - Exact match. If none found, return #N/A. This is the default.
-1 - Exact match. If none found, return the next smaller item.1 - Exact match. If none found, return the next larger item.


Other additional features that the addon can perform are as listed below:
compare names similarity for google sheets.
vlookup with text similarity for google sheets.
vlookup text contains in google sheets.
Compare address and names similarity.
vlookup approximate match text
vlookup if cell contains a word within 

अतिरिक्त जानकारी
कीमतउपलब्‍ध नहीं
डेवलपर
डेवलपर के व्यापारी होने या न होने की जानकारी नहीं है
सेवा की शर्तें
Xlookup for Sheets नीचे दी गई अनुमतियों के ऐक्सेस का अनुरोध करेगा. ज़्यादा जानें
Xlookup for Sheets को आपके Google खाते के ऐक्सेस की ज़रूरत होगी
इससे Xlookup for Sheets के दायरे में ये अनुमतियां भी शामिल हो जाएंगी :
आपकी सभी Google Sheets स्प्रेडशीट देखना, उनमें बदलाव करना, नई स्प्रेडशीट बनाना, और उन्हें मिटाना
Google ऐप्लिकेशन में प्रॉम्प्ट और साइडबार में तीसरे पक्ष का वेब कॉन्टेंट दिखाएं और चलाएं
किसी बाहरी सेवा से कनेक्ट करें
आपके Google खाते का मुख्य ईमेल पता देखना
सोशल मीडिया पर दी गई किसी भी जानकारी के साथ, अपनी निजी जानकारी देखें
समीक्षाएं
भाषा:
इस क्रम में लगाएं:
Google, समीक्षाओं या रेटिंग की पुष्टि नहीं करता. समीक्षाओं के बारे में ज़्यादा जानें
कोई टिप्पणियां नहीं
खोजें
खोज हटाएं
खोज बंद करें
Google ऐप
मुख्य मेन्यू