Excel Lists - get an item in a list to automatically bring in info

  • Thread starter Thread starter fireman112473
  • Start date Start date
F

fireman112473

I am using a list to select an item - with that item is certain specification
that need to appear for doing come calculations. I tried with the IF
statement and it work but only for seven items and I have about 25 items that
it needs to recognize. What would an easier way of accomplishing this be?

Thanks for any help.
 
Use VLOOKUP() to get the specification once the value has been pick up from
the list.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection of drop down list directs auto population of other cell 1
Excel Vlookup Help 0
Linking other cells to a list item 1
Adding some list items 1
Use word to associate an item in validation drop down list 2
Validation lists... 4
ADD ITEM TO A DROP DOWN LIST? 4
Data Validation - Can 2 items from a list be combined? 2

Back
Top