| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Lists - get an item in a list to automatically bring in info
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Lists - get an item in a list to automatically bring in info
Use VLOOKUP() to get the specification once the value has been pick up from
the list. -- Gary''s Student - gsnu200789 "fireman112473" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Lists - get an item in a list to automatically bring in
I've never used that command - how would that work
"Gary''s Student" wrote: Use VLOOKUP() to get the specification once the value has been pick up from the list. -- Gary''s Student - gsnu200789 "fireman112473" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What function-bring me the info in the next column-same row? | Excel Worksheet Functions | |||
| Automatically fill info from a list | Excel Worksheet Functions | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
| Lists: Clicking on one item in one list and getting certain info i | Excel Worksheet Functions | |||
Linear Mode
