insert data from seperate worksheet into seperate colums depending on list selection

  • Thread starter Thread starter RPIJG
  • Start date Start date
R

RPIJG

Well I tried to cram all the information into the subject, but to tr
and elaborate a bit more.

I am trying to make it so that I can select an item from a drop dow
list (the list part I can do) and then have it enter values preset fo
that list item into 4 seperate columns.


For example:

If I select Item #1 Then a 4 different values are automaticall
inserted into 4 different columns.

So Item #1 has a weight of 1, a price of 3, a description of Thi
thing, and a Value of 5. I want to be able to select Item #1 from th
drop down list and then have the columns next to it automaticall
insert those values into them on the worksheet.

Am I making sense?

Thanks for all your help.

Jo
 
A simple Vlookup will do exactly what you wish, IF your DataList is set-up
so that the "Item #" from the drop down list is to the left of the data that
you wish to be returned from your DataList.

For example,
Drop down list starts in A1,

DataList is V1:Z100,
With Item # in column V.

Enter this formula in B1:
=VLOOKUP(A1,$V$1:$Z$100,2,0)

Enter this formula in C1:
=VLOOKUP(A1,$V$1:$Z$100,3,0)

Enter this formula in D1:
=VLOOKUP(A1,$V$1:$Z$100,4,0)

Enter this formula in E1:
=VLOOKUP(A1,$V$1:$Z$100,5,0)

Select all four cells, and drag down to copy as needed.

If your DataList is constructed where the item number is *not* to the left
of the data to be returned, then the use of a combination of the Index and
Match functions will give you similar results.
Post back if you would need help with these functions.
 
Thank you very much for your help, that worked out just as I would hav
liked it to.

Your help has been greatly appreciated.

Thanks

Jo
 
Back
Top