Scribd
Upload
54 views4 pages

Numbers Text Dates Numbers Numbers

The document contains a table with numbers, text, and dates. It also contains multiple tables with product information including codes, quantities, and prices.

Uploaded by

Aslam Rehman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
54 views4 pages

Numbers Text Dates Numbers Numbers

The document contains a table with numbers, text, and dates. It also contains multiple tables with product information including codes, quantities, and prices.

Uploaded by

Aslam Rehman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 4

Numbers Text Dates Numbers Numbers

10 Monday 11/3/2022 10 10
55 Tuesday 12/3/2022 20 20
30 Wednesday 13/3/2022 30 30
40 Thursday 14/3/2022 40 40
50 Friday 15/3/2022 50 50
60 Saturday 16/3/2022 60 60
6 Sunday 17/3/2022 70 70
80 Monday 18/3/2022 80 80
90 Tuesday 19/3/2022 90 90
100 Wednesday 20/3/2022 100 100

10
Numbers Numbers Numbers Numbers Numbers
10 10 90 10 10
20 20 80 20 20
30 30 90 30 30
40 40 100 40 40
50 50 20 50 50
60 60 30 60 60
70 70 40 70 70
80 80 50 80 80
90 90 60 90 90
100 100 70 100 100

20 30 40 50 60
Vlookup exact Match Clothes 8.95

Top Products Product Code Quantity Price


Mobile 1000-165-B100 25 $26.95
Camera 1001-540-C101 20 $28.95
Watches 1002-394-M102 35 $31.95
Cosmetics 1002-307-Q103 20 $35.95
Shoes 1003-848-S104 30 $18.95
Laptops 1004-155-S105 40 $20.95
Perfumes 1005-522-T106 1 $4.95
Clothes 1006-634-O107 5 $8.95

Top Product Price Unit Total


Shoes 18.95 4 75.8

Vlookup and Data Validation


Top Product Price Unit Total
Laptops 20.95

Vlookup with Named Range


Top Product Price Unit Total
Perfumes 4.95
Top Products Product Code Quantity Price
Mobile 1000-165-B100 25 $26.95
Camera 1001-540-C101 20 $28.95
Watches 1002-394-M102 35 $31.95
Cosmetics 1002-307-Q103 20 $35.95
Shoes 1003-848-S104 30 $18.95
Laptops 1004-155-S105 40 $20.95
Perfumes 1005-522-T106 1 $4.95
Clothes 1006-634-O107 5 $8.95

You might also like