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

[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.

 

[Gary''s Student]

Use VLOOKUP() to get the specification once the value has been pick up from
the list.

 

[fireman112473]

I've never used that command - how would that work