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.

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.

Thank you for the response. I was able to get it working with this formula

=VLOOKUP(C13,data!B2:C85,2,FALSE)
vlookup worked great, I just needed to figure out how to get it to reference
data from another tab and move to the proper column in the tab

"Pete_UK" wrote:

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.

Thanks for feeding back, Ted - glad you found something that works for
you.

Pete

On Apr 15, 7:41*pm, Ted wrote:
Thank you for the response. I was able to get it working with this formula

=VLOOKUP(C13,data!B2:C85,2,FALSE)
vlookup worked great, I just needed to figure out how to get it to reference
data from another tab and move to the proper column in the tab



"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -