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, 2022 in Database by Edureka
• 13,690 points
2,115 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, 2022 by gaurav
• 23,260 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, 2022 in Database by Kithuzzz
• 38,000 points
586 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, 2022 in Database by Kithuzzz
• 38,000 points
864 views
0 votes
0 answers

Create a SQL enter script from an Excel worksheet

I have a large excel worksheet that ...READ MORE

Sep 8, 2023 in Database by Satyawrat
• 460 points
561 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
2,046 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, 2022 in Database by gaurav
• 23,260 points
1,666 views
0 votes
1 answer

Remove duplicates within a row

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

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
669 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, 2022 in Database by gaurav
• 23,260 points
5,253 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