ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Lists - get an item in a list to automatically bring in info (https://www.excelbanter.com/excel-discussion-misc-queries/189123-excel-lists-get-item-list-automatically-bring-info.html)

fireman112473

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.

Gary''s Student

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.


fireman112473

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