![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com