quite

you have to build a legend in order for excel to know the proper shortcut
for each name. make a list, one column is the the name (nokia) and on the
column on the right is the shortcut (nok)

after you do this, use this formula to make the new unified list

=CONCATENATE(VLOOKUP(F11,J11:K13,2,0)," ",G11)

obviously you have to make some changes for this formula to fit your
spreadsheet: F11 is a reference to the cell the name is in. G11 - the cell
the serial number's in. J11:K11 the range of cells the legend is in.

use the pull brush to copy this function to as much rows as there are on the
other lists. (this will work if the list you make is on the same sheet as the
other 2) if you want to move this list to another sheet or delete the
previous 2 without losing the resulting list, copy the new list and go to
edit - paste special: choose "values" and ok. then you're clear.

"themax16" wrote:


Afternoon everybody....

I have a pair of text based lists running down a worksheet.. i need to
create a 3rd list that is made up from the information in lists one and
two.

Eg.

List one List two List three (PLU)

Sony ericsson P900 SE P900
Nokia 6230 NOK 6230

As you can see the LPU is extracted from the Make and model.
Is it possible to set up some formulation for this?

Thanks
James


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=390520