So I don't know if this is possible, but here is what I want to do: I have a list of about 100 golf drivers with 4 characteristics each. I have created a 5 digit name for each driver, and listed the 4 characteristics in the cells below. For example:
T2543
Titleist
460cc
45 Inches
New
S4522
Taylor Made
410cc
44 Inches
Used
etc...
The pricing excel tab I use has 5 rows that correspond to each of the characteristics above. Instead of manually typing in "T2543, Titleist, 460cc, 45 Inches, etc" for each driver, I would like to use a drop-down that automatically pulls the info for each driver code. That is, the drop-down would list T2543, S4522, etc. Once selected, it would populate the 4 characteristics into the cells below.
I am thinking it would take another tab from which a formula draws. Everything I have found thus far regarding drop downs, however, only results in output that is one cell.
Hopefully this makes sense. I am a new at this. If you can point me in the right direction, I would appreciate it.
Thanks.
Bookmarks