VLookup I think?
 

I would appreciate some help with a spreadsheet I am creating.
I have set up validation with two list options and following it has
cells for inputing information. What I want to do is have the
information following the validation to be combined with the other
like validation's throughout the sheet, then transposed onto another
sheet.
I hope I explained this acurately, and appreciate any help you can
provide.


--
ErikT
------------------------------------------------------------------------
ErikT's Profile: http://www.excelforum.com/member.php...o&userid=32042
View this thread: http://www.excelforum.com/showthread...hreadid=517902