Lookup Functions
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Lookup Functions as PDF for free.
More details
- Words: 567
- Pages: 10
Lookup Functions Row Rows Column Columns Lookup
16 7 6 11
Name ahmad arbab ihsan imran jamil khalid khan majid rafi salim samim wahid wajid
post teacher accountant teacher teacher doctor doctor teacher engineer engineer engineer accountant engineer doctor
salary 8000 13000 1000 3000 9000 11000 2000 6000 5000 7000 12000 4000 10000
Name samim
post accountant
Salary 12000
Vlookup Hlookup match index
vertical lookup horizental lookup
RollNo
Name 1 khan 2 imran 3 wahid 4 rafi 5 majid 6 salim 7 ahad 8 amir 9 jamil
Urdu
English 23 4 54 3 3 4 55 44 23
34 22 33 43 66 45 23 43 32
Computer Physics 65 34 34 55 34 43 54 23 34 56 23 54 45 34 34 22 34 33
Detailed Marks Certificate Roll No: Name:
S.No
Subject 1 Urdu 2 islamiat 3 computer 4 english 5 mathes 6 biology 7 physics 8 chemistry Percentage
TotalMarks
9 jamil
Obtianed Marks Result 100 23 fail 75 23 fail 75 34 fail 100 32 fail 100 23 fail 50 fail 50 33 Pass 50 23 fail 600 191 fail 31.83
e
Chemistry Islamiat Mathes 23 23 34 23 23 44 43 55 44 23 56 55 33 44 44 23 23 23
34 34 22 32 23 23 23 23 23
Lookup functions Row Rows Column Columns Lookup Vlookup Hlookup Mathc Index
Usage 13 19 9 7
Name Ajmal Alam Fahmeed Fareed Haroon Javeed Naim Nasir Qadeer Qamar Rafi Sabir Shah Shams Shawaly Waris Zabih
Post Engineer Teacher Engineer Teacher Doctor Teacher Engineer Doctor Peon Acountant Acountant Teacher Engineer Doctor Peon Engineer Acountant
Salary
Name Nasir
Post Doctor
4200 3600 4000 3800 2000 1200 1400 2200 3400 2600 2800 1000 1800 2400 3200 1600 3000
Salary 2200
Roll No:
Name 1 Ajmal 2 Alam 3 Fahmeed 4 Fareed 5 Haroon 6 Javeed 7 Naim 8 Nasir 9 Qadeer 10 Sabir
Urdu
English 35 60 30 40 50 45 40 80 50 60
Maths 40 35 40 65 35 45 60 40 50 70
Islamiat 70 50 54 65 35 25 40 70 60 90
60 80 55 40 35 45 65 35 25 40
Detail Marks Certificate Roll No:
10
Name:
Roll No:
Subject 1 Urdu 2 English 3 Maths 4 Islamiat 5 Computer 6 Physics 7 Chemistry 8 Biology Net total Percentage
Sabir
Total marks 75 75 100 80 60 100 100 80
Obtained marks Result 60 Pass 70 Pass 90 Pass 40 Fail 50 Pass 50 Fail 80 Pass 60 Pass
670 74.63
500 Pass
Computer
s Certificate
Physics 50 40 55 85 35 65 85 90 40 50
80 20 50 30 60 30 50 60 40 50
Chemistry Biology 30 35 65 40 30 20 60 30 40 80
30 50 60 40 25 35 25 40 50 60
Name post salary Sabir Gulzamain Shirzad Afghany Salahudeen
e am
N Nasir Ali Ahmad Qadeer Fareed Javeed Shams Nadeem Fahmeed Almas Wahid
t os
P Teacher Engineer Teacher Teacher Doctor Teacher Engineer Teacher Doctor Engineer Teacher
bonus
total
tus
ta Ms
Married Married Single Married Single Married Married Single Married Single Married
Paid
ry
la Sa
6000 12000 8000 10000 14000 13000 15000 10000 18000 20000 9000
Balance
us
n Bo
1200 0 0 2000 0 2600 0 0 0 0 1800
tal To 7200 12000 8000 12000 14000 15600 15000 10000 18000 20000 10800
Confirmation Confirmed Incorrect Confirmed
16 7 6 11
Name ahmad arbab ihsan imran jamil khalid khan majid rafi salim samim wahid wajid
post teacher accountant teacher teacher doctor doctor teacher engineer engineer engineer accountant engineer doctor
salary 8000 13000 1000 3000 9000 11000 2000 6000 5000 7000 12000 4000 10000
Name samim
post accountant
Salary 12000
Vlookup Hlookup match index
vertical lookup horizental lookup
RollNo
Name 1 khan 2 imran 3 wahid 4 rafi 5 majid 6 salim 7 ahad 8 amir 9 jamil
Urdu
English 23 4 54 3 3 4 55 44 23
34 22 33 43 66 45 23 43 32
Computer Physics 65 34 34 55 34 43 54 23 34 56 23 54 45 34 34 22 34 33
Detailed Marks Certificate Roll No: Name:
S.No
Subject 1 Urdu 2 islamiat 3 computer 4 english 5 mathes 6 biology 7 physics 8 chemistry Percentage
TotalMarks
9 jamil
Obtianed Marks Result 100 23 fail 75 23 fail 75 34 fail 100 32 fail 100 23 fail 50 fail 50 33 Pass 50 23 fail 600 191 fail 31.83
e
Chemistry Islamiat Mathes 23 23 34 23 23 44 43 55 44 23 56 55 33 44 44 23 23 23
34 34 22 32 23 23 23 23 23
Lookup functions Row Rows Column Columns Lookup Vlookup Hlookup Mathc Index
Usage 13 19 9 7
Name Ajmal Alam Fahmeed Fareed Haroon Javeed Naim Nasir Qadeer Qamar Rafi Sabir Shah Shams Shawaly Waris Zabih
Post Engineer Teacher Engineer Teacher Doctor Teacher Engineer Doctor Peon Acountant Acountant Teacher Engineer Doctor Peon Engineer Acountant
Salary
Name Nasir
Post Doctor
4200 3600 4000 3800 2000 1200 1400 2200 3400 2600 2800 1000 1800 2400 3200 1600 3000
Salary 2200
Roll No:
Name 1 Ajmal 2 Alam 3 Fahmeed 4 Fareed 5 Haroon 6 Javeed 7 Naim 8 Nasir 9 Qadeer 10 Sabir
Urdu
English 35 60 30 40 50 45 40 80 50 60
Maths 40 35 40 65 35 45 60 40 50 70
Islamiat 70 50 54 65 35 25 40 70 60 90
60 80 55 40 35 45 65 35 25 40
Detail Marks Certificate Roll No:
10
Name:
Roll No:
Subject 1 Urdu 2 English 3 Maths 4 Islamiat 5 Computer 6 Physics 7 Chemistry 8 Biology Net total Percentage
Sabir
Total marks 75 75 100 80 60 100 100 80
Obtained marks Result 60 Pass 70 Pass 90 Pass 40 Fail 50 Pass 50 Fail 80 Pass 60 Pass
670 74.63
500 Pass
Computer
s Certificate
Physics 50 40 55 85 35 65 85 90 40 50
80 20 50 30 60 30 50 60 40 50
Chemistry Biology 30 35 65 40 30 20 60 30 40 80
30 50 60 40 25 35 25 40 50 60
Name post salary Sabir Gulzamain Shirzad Afghany Salahudeen
e am
N Nasir Ali Ahmad Qadeer Fareed Javeed Shams Nadeem Fahmeed Almas Wahid
t os
P Teacher Engineer Teacher Teacher Doctor Teacher Engineer Teacher Doctor Engineer Teacher
bonus
total
tus
ta Ms
Married Married Single Married Single Married Married Single Married Single Married
Paid
ry
la Sa
6000 12000 8000 10000 14000 13000 15000 10000 18000 20000 9000
Balance
us
n Bo
1200 0 0 2000 0 2600 0 0 0 0 1800
tal To 7200 12000 8000 12000 14000 15600 15000 10000 18000 20000 10800
Confirmation Confirmed Incorrect Confirmed
Related Documents
Lookup Functions
May 2020 1
Excel Lookup Functions Explained
November 2019 15
Lookup Table
November 2019 7
H Lookup
May 2020 1
Vertical Lookup
October 2019 10