Keep Column Information Together--Possible?

[ND]

I have information in three columns. The column headings
are Proj #, Proj Name & Proj Desc. I have created a
userform that I would like for the information from these
three columns to automatically fill in. I know that I can
link each column to another worksheet or workbook,
however, I would like to know if it is possible for the
the proj #, proj name & proj desc to stay together for
each respective project.

What I mean is there are 8 projects each with a proj #,
proj name and proj desc. If I select Proj #4 from the
drop down box, is there a way for me to also get the proj
name and proj desc that coincides with proj #4? Is it
possible for me to select TSC5 from the drop down box
and "TSC 5" show up in the Project #, "Pager" show up in
the Project Name and "Alpha vs numeric" show up in the
Project Objective(s)?

Hopefully, this information below helps to clarify what I
am trying to do. Unfortunately, I am not able to post
HTML.

This is my worksheet of information:
A B C
1 TSC1 Telephone Phone Type
2 TSC2 Move Entire group/individual
3 TSC3 Adds New hire
4 TSC4 Changes Promotion
5 TSC5 Pager Alpha vs. numeric
6 TSC6 Cell phone Carrier
7 TSC7 PC Desktop/Laptop
8 TSC8 Conversion Migration Issues


I would like it to go in a form where the cells are lined
up like this:
A B C
1 Project #:________ Project Name:_______________________
2
3 Project Objective(s):_______________________________

 

[Dave Peterson]

If you let your user choose TSC5, you could use a couple of formulas to return
the info.

=vlookup(B1,sheet1!$b$1:$c$99,2,false) for the description
=INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0)) for the first column (project #)

(I kind of got lost on which fields were which. They got jammed together.)

(I'd put the key value in column A and then use two =vlookup's.)

 

[davis1189]

Hi Dave, thank you very much for this code, however, since I don't know
code very well---I am still lost. LOL!

Do you mind if I try to make it a little more understandable with the
attached document?

Thanks!

File Attached: http://www.exceltip.com/forum/attachment.php?postid=290608 (projstatform.xls)

 

[Dave Peterson]

The attachment wasn't there. (And nowadays, I don't think I'd open it anyway.)

But there wasn't any code in that response. It was just some worksheet
formulas.

Since your form looked like this:

1 Project #cell B1) Project NameCell D1???)
2
3 Project Objective(s): (cell c3????)

You could have the controlsource (linked cell for combobox on the userform)
point directly at B1 of that sheet.

then in C3, you could use the first formula:
=vlookup(B1,sheet1!$b$1:$c$99,2,false) for the description

And in D1, you could use this.
=INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0)) for the first column (project #)