Make a table that list all the company names and expected notation and
sort it. It will look something like this:

Nokia NOK
Sony ericsson SE

Your third list will be:

=CONCATENATE(VLOOKUP(D1,$A$1:$B$2,2)," ",E1)

where D1 is your List one, E1 is your list two, $A$1:$B$2 is the
vlookup table.


Hope it helps.




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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390520