Excel - Create item list from table values

0 votes

I have a table of tools that are currently on our construction sites with how many of each tool is on each site which looks something like this:

Item Table

I'm trying to create a formula that will list the tools that are on the site and skip those that aren't with the quantity listed next to the tool. I tried creating a drop down list of the top row that will determine which column the formula looks down - seemed simple enough on paper but I'm struggling to put it into practice.

Any advice is appreciated. Thanks

Apr 6 in Database by Edureka
• 13,640 points
242 views

1 answer to this question.

0 votes

What is Data Validation, and how does it work?
The data validation tool in Microsoft Excel allows you to limit what can be entered in your worksheet. You can, for example:

restrict entries, such as a date range or entire integers, by creating a drop down list of objects in a cell Make specific rules for what can be entered exclusively.

list of options for drop down

What Is a Drop Down List and How Do I Make One?
You can build a dropdown list of options in a cell using Data Validation. There are three simple steps to follow:

1. Make a table of contents OR a list

2. Give the List a Name

3. Make the drop-down menu

Data validation is not without flaws. It can be avoided by pasting data into the cell or using the Ribbon's Home tab's Clear > Clear All option.

list of options for drop down

list of options for drop down

list of options for drop down

answered Apr 11 by gaurav
• 22,040 points

Related Questions In Database

0 votes
0 answers

Create table (structure) from existing table

How to create a new table in ...READ MORE

Aug 28 in Database by Kithuzzz
• 20,460 points
31 views
0 votes
0 answers

How to create a table from select query result in SQL Server 2008

I tried to build a table from ...READ MORE

Sep 2 in Database by Kithuzzz
• 20,460 points
87 views
0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 25, 2019 in Database by sampriti
• 1,120 points
1,083 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
747 views
0 votes
1 answer
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
574 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
78 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
387 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP