Scribd
Upload
7 views1 page

Employee Salary and Fruit Inventory Data

The document presents a table of employee information including IDs, names, and salaries, with notable entries such as Mila Clark earning $188,657. It also includes a Vlookup section with employee details like emails and IDs, and a Hlookup section detailing fruit prices and stock levels. The data is structured to facilitate easy reference for salaries and contact information.

Uploaded by

m20018001
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

Employee Salary and Fruit Inventory Data

The document presents a table of employee information including IDs, names, and salaries, with notable entries such as Mila Clark earning $188,657. It also includes a Vlookup section with employee details like emails and IDs, and a Hlookup section detailing fruit prices and stock levels. The data is structured to facilitate easy reference for salaries and contact information.

Uploaded by

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

INDEX Formula

ID First Name Last Name Salary


72 Emily Smith $64,901.00
66 James Bond $70,855.00
14 Mila Clark $1,88,657.00
30 John Lewis $97,566.00
53 Jessica Walker $58,339.00
56 Mark Reed $1,25,180.00
79 Richard Loper $91,632.00
ID 14
Salary $1,88,657.00
Vlookup
ID First Last Email
610 Janet Farley [Link]@[Link] ID 867
798 Steven Batista [Link]@[Link] First Erica
841 Evelyn Monet [Link]@[Link] Last Tan
886 Marliyn Adder [Link]@[Link] Email [Link]@[Link]
622 Jonathan Birt [Link]@[Link]
601 Adrian Irons [Link]@[Link]
869 Julie Bradley [Link]@[Link]
867 Erica Tan [Link]@[Link]
785 Harold Clayton [Link]@[Link]
648 Sharyn Castor [Link]@[Link]
Hlookup
Fruit Apples Bananas Lemons Oranges Pears Almonds Cashews
Price 8 5 6 5 8 4 9
Stock 121 130 132 146 124 146 139
Fruit Price Stock
Pears 8 124

You might also like