Try this:

=INDEX(list2,MATCH(B1,list1,0))

Hope this helps.

Pete

On Apr 15, 4:25*pm, Ted wrote:
I need help with a formula. I have two named lists in tab #2. List 1 is a
product part number, list 2 is the part description.

In tab 1 I have data validation set in column B to pull a dropdown with the
values in the part number list . I am trying to figure out to get Column C to
automatically pull the values in the part description based on the value
selected from the part number.

In tab #2 the part number and part description are always on the same row in
adjoining columns.

Any help is greatly appreciated.