Excel Forum

Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick

See how to create a new column of values joining a value from the 1st column that contains company names and blanks and a second column with Product name. Aladin from the Mr Excel Message Board provides a cool efficient formula to solve this problem.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.