How to use vlookup function in excel_pepare salary slip

  Рет қаралды 39,160

Professional Excel Trainer

Professional Excel Trainer

Күн бұрын

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.
How to Import Contacts from excel to gmail | How to save contacts on phone via gmail at once
• How to Import Contacts...
Top 15 Advanced Excel 2016 Tips and Tricks
• Top 15 Advanced Excel ...
Top 5 Financial Functions in Microsoft Excel
• Top 5 Financial Functi...
How to use vlookup function in excel
• How to use vlookup fun...
how to use PRICE function in excel with examples_financial function-04
• how to use PRICE funct...
how to use EFFECT function in excel with examples_financial function-03
• how to use EFFECT func...
how to use DB function in excel with examples_financial function-02
• how to use DB function...
how to use accrint function in excel with examples_financial function-01 • how to use accrint fun...
How to Use Data Slicers in excel_rarely know feature • How to Use Slicers in ...
Small Function in excel_ how to find 2nd smallest value in a list in excel • How to use small funct...
How to use TRIM function to remove extra space in excel • How to use TRIM functi...
top 3 count formula in excel in urdu • top 3 count formula in...
how to separate first and last name in excel in urdu • separate first and las...
how to use goal seek in excel • Goal seek function in ...
how to use advanced filter in excel • Excel 2016 Advanced Fi...
how to use define name in excel • how to Define Names in...
how to use filter in excel • Video
how to use go to special in excel • How To Use Go To Speci...
how to use flash fill in excel • Video
how to use freeze pans in excel • Video
Transpose Command in Excel • How to use transpose i...
Quickly Learn How To Use The LOWER, UPPER & PROPER Function In Excel • Quickly Learn How To U...
Lock Cells & Protect Sheet in Excel || Urdu • how to Lock Cells & Pr...
#professionalexceltrainer
#vlookupfunction
/ mahboob2023

Пікірлер: 21
@pragyapriyaphukan4992
@pragyapriyaphukan4992 9 ай бұрын
thank You sir, You saved my performance appraisal. I have seen many videos since 4 days but was in vain. Your video helped me today to finally make auto-payroll.
@Cherry-id6wo
@Cherry-id6wo 9 ай бұрын
Assalamualaikum, thank you so much for this excel I've been trying to do it for ages. ❤
@manojthakur-xo8uq
@manojthakur-xo8uq 2 жыл бұрын
Thank you sir for sharing your experience 😊
@shabrotherss
@shabrotherss 5 ай бұрын
Thank you for your tutorial
@niniwin4125
@niniwin4125 4 жыл бұрын
Thank u so much for your sharing.
@pavankrishna163
@pavankrishna163 4 жыл бұрын
Excellent sir, thank u soooooo much sir
@vaasudevmallika
@vaasudevmallika Жыл бұрын
Thank you very much sir
@hemantsoni3982
@hemantsoni3982 3 жыл бұрын
Sir how to make this table please make a video. And thank u for this video
@professionalexceltrainer85
@professionalexceltrainer85 3 жыл бұрын
Inshallah very soon
@prakashisari4422
@prakashisari4422 Жыл бұрын
Thank u sir
@professionalexceltrainer85
@professionalexceltrainer85 Жыл бұрын
Welcome
@nishimundan9414
@nishimundan9414 2 жыл бұрын
Nice.. You are very handsome
@supershakti91
@supershakti91 9 ай бұрын
What about for employee 35
@addu4034
@addu4034 Жыл бұрын
This is very tiresome. Is there any other method where changing only one of the details ( code or name) will change all the other details accordingly?
@professionalexceltrainer85
@professionalexceltrainer85 Жыл бұрын
Sir plz share if you have any better solution.
@SALMANAHMEDH
@SALMANAHMEDH Жыл бұрын
Bhai assalam mai ek cheez mai atak gaya hu please help
@professionalexceltrainer85
@professionalexceltrainer85 Жыл бұрын
Batain
@SALMANAHMEDH
@SALMANAHMEDH Жыл бұрын
@@professionalexceltrainer85 Nahi ab ho gaya hai resolve Thank you 👍
@zebahashmi99
@zebahashmi99 Жыл бұрын
Bhai assalam walekum
@professionalexceltrainer85
@professionalexceltrainer85 Жыл бұрын
W.s
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 214 М.
Apple peeling hack @scottsreality
00:37
_vector_
Рет қаралды 123 МЛН
I Took a LUNCHBAR OFF A Poster 🤯 #shorts
00:17
Wian
Рет қаралды 16 МЛН
Dad Makes Daughter Clean Up Spilled Chips #shorts
00:16
Fabiosa Stories
Рет қаралды 8 МЛН
Advanced Excel - VLOOKUP Basics
11:58
Technology for Teachers and Students
Рет қаралды 2,2 МЛН
Understanding VLOOKUP - Salary Consolidation
18:05
CHAMP EXCEL
Рет қаралды 12 М.
How to Use VLOOKUP to Compare Two Lists
15:20
Simon Sez IT
Рет қаралды 812 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,3 МЛН
Compare Two Lists Using the VLOOKUP Formula
12:49
Computergaga
Рет қаралды 2,9 МЛН
How To Use Index Match As An Alternative To Vlookup
19:28
Excel Campus - Jon
Рет қаралды 1,6 МЛН
MS Excel - Vlookup in Excel Video Tutorials
6:38
TutorialsPoint
Рет қаралды 10 МЛН
Apple peeling hack @scottsreality
00:37
_vector_
Рет қаралды 123 МЛН