✔️ XLOOKUP ❌ VLOOKUP in Excel Telugu || 8 Reasons || Differences between XLOOKUP & VLOOKUP in Excel

hi VI welcome to computer Ms very very important formula [Music] first of all look value s name IND number 1 2 3 four Commission okay now comma and true approximate match false exact match exact mat9 dat employ detal look 154 2782 equ us your formula X look up equal toiss look EMP 7286 EMP Raju 6,318 corre formula equal x name custom message name [Music] okay equal x okay and commission ENT remaining Sal Place sales commission sales value 5,641 and 2782 Sal Val 20,000 20,000,000 4% 40,000,000 7 8000% SE minus one exact match or next smaller item okay sales value ,000 so% 4,000,000 sales okay different different EMP okay equal to X look value message again comma character match 77000 last EMP name7 use formula X lookup and last one two look 202 equal second again cl21 gopy 2021 77,6 45 201844 sales 64300 C as form macro enabled work thank you thank you very [Music] much

Channel: Computers adda

Views: 55,441

Keywords:

Id: y2BehwCml6g

Length: 20min 26sec (1226 seconds)

Published: Mon Nov 27 2023