Cədvəlin sütunlarından məlumatları gətirmək üçün istifadə edilir. Prinsipcə VLOOKUP-a bənzəsə də ondan daha çevik və daha ətraflıdır.
Sintaksisi: =XLOOKUP(lookup_value, lookup_array, return_array [if_not_found], [match_mode], [search_mode]).@misterexcel
1 view
590
277
5 months ago 19:23:46 1
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
7 months ago 02:31:06 1
20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial
8 months ago 00:16:20 1
XLOOKUP aka ПРОСМОТРX – Эволюция ВПР! - Функции Excel (12)
8 months ago 00:55:38 1
EXCEL PORTFOLIO PROJECT | Build this Interactive Dashboard
12 months ago 00:01:43 1
XLOOKUP function in Excel - XLOOKUP funksiyası
1 year ago 00:02:42 1
Функция ВПР в Excel. За 3 минуты простыми словами и на примере.
2 years ago 00:00:48 1
Vlookup Formula | Vlookup Excel #shorts #viral #excel #shortsfeed
2 years ago 03:44:08 4
Excel & Power BI Data Analysis Complete Class in One Video - 365 MECS 04
2 years ago 02:16:16 1
Excel for Business Analysts Crash Course (XLOOKUP, IF, Forecast Sheets & More!)
3 years ago 00:17:04 1
Excel Урок 51. Функция ПросмотрХ (XLookup) чем лучше ВПР (Vlookup). Разбираем подробно на примерах
4 years ago 00:06:58 2
Excel Trick: Sum a Specific Number of Cells
4 years ago 00:23:08 1
Xlookup Function in Excel (Hindi) | XLOOKUP IN HINDI | New Formula in Excel | What is Xlookup? | MIS