Link together different cells in specific order?

**Sandman4432** · 12-31-2007, 04:13 PM

Hi all,

I have a list of terms to put together and what I have is a master list of 6 concatenate functions and I need to link them to all the different words in my list.
The first word in collumn A needs to be with the function in D1, the second word (A2) needs to be with D2, then A3 with D1, and A4 also with D1, while A5 with D6, etc.
It looks something like this:
for your info...I have put numbers in the adjacent cell corresponding to which of the 6 concatenate functions need to go into the cell in collumn C

So in reality all I need is a function that would rearrange my list of 6 functions from Collumn D into collumn C based on the numbers 1-6 I have in collumn B

Workbook.txt

(attached is an example to better see what im talking about. Disregard that the concatenate functions are not working...it doesnt matter right now.)

I hope that makes sense it is a bit hard to explain but let me know if you don't quite understand.

**shg** · 12-31-2007, 04:25 PM

I don't understand at all. can you post a workbook with a sample of source data and expected output?

**Sandman4432** · 12-31-2007, 04:55 PM

As I read over what I posted I cringed at how hard it is to explain. I thought that the linked attachment would help. It is the outcome. In collumn A are sample terms that I have. In collumn D are the 6 functions. Collumn B are the numbers 1-6 that correspond to which I want.... 1 meaning D1, 2 meaning D2, 3 meaning D3, and so on.

Basically once again I am trying to find a function that may be an if then. If the number 5 is in B1 then D5 needs to show up in C1. If the number 1 is in B26 then what is in D1 needs to show up in C26. If the number 3 is in B27 then what is in D3 needs to show up in C27...is that clearer?

Workbook.xls.zip

I hope that the attachment works this time...i dont know why i put it in .txt the first time.

**VBA Noob** · 12-31-2007, 05:03 PM

Can't open your attachment.

Is it a 2007 xl file

VBA Noob

**Sandman4432** · 12-31-2007, 05:31 PM

Well it is supposedly a default excel file format....hmmm its not 2007 either.

Lets try once more

Workbook 2.htm.zip

**Sandman4432** · 12-31-2007, 05:42 PM

Lol i did because you couldnt see what I had posted last time....gees I was trying to find some common ground just so you could see what I was talking about not get the excel user all in a huff cause I used another format. Ill try the excel sheet again but if it doesn't work there isn't much else I can do then some other more universal format.

Workbook 2.xls.zip