Adding Values to predefined fields

[cashton59]

Hello,
Sorry if this was posted before but I am having a little trouble. What I am trying to is this:
I have the below:

California Los angeles 2007
California Los angeles 2006
California Los angeles 2005
California Pomona 2007
California Pomona 2006
California Pomona 2005
Arizona Tempe 2007
Arizona Tempe 2006
Arizona Tempe 2005
Arizona Scottsdale 2007
Arizona Scottsdale 2006
Arizona Scottsdale 2005


Now I have values for each of those:
California Los angeles 2007 is 1001 1021 1031
California Los angeles 2006 is 9001 9021 9031
etc.

I have a bunch of them and need a formula to basically append all the values (1001 1021 1031) to every California Los Angeles 2007 and so forth for every value. Basically if 3 values are x then append y. but if 3 values are xy then append yx. Am I making any sense?? ha

Any help is appreciated!
-Cash

[rylo]

Hi

VLOOKUP will probably be able to give you what you are chasing, but can you please put up an example file with your data, and also a list of the values for each of the items, and how you would like the output to appear.

rylo