Excel 2007 : CONCATENATE a string longer than 255 characters

I have a concatenate string that is longer than 255 characters. See below. Is there a way to write this statement grouping the J3's (ie J3=3.5 three times in this equation, just the J4 cell is different).

=CONCATENATE(IF(AND(J3=3.5,J4=3.2),"3.250",""),IF(AND(J3=3.5,J4=4),"3.185",""),IF(AND(J3=3.5,J4=4.8),"3.125",""),IF(AND(J3=4.5,J4=3.2),"4.250",""),IF(AND(J3=4.5,J4=4),"4.185",""),IF(AND(J3=4.5,J4=4.8),"4.125",""),IF(AND(J3=6.625,J4=4),"6.310",""),IF(AND(J3=6.625,J4=3.2),"6.375",""),IF(AND(J3=8.625,J4=4),"8.249",""))

Thanks

What's the point of CONCATENATE at all? Why would anybody ever use it?

So concatenate isn't the right way to go. I need to ferret out the right number for each pairing

ie OD = 3.5
WT = either 3.2, 4.0 or 4.8
If the WT is equal to 3.2 the answer is 3.250, etc.

but I have 4 different OD's that I need to look at, each with three WT's that will respond with a different answer for each.

Probably the neatest way to do this is to have a look-up table and then use INDEX and MATCH to return a value from it.

That makes the formula manageable and also makes it much easier to maintain.

I've set up your values in a very simple workbook and put the lookup formula in J5.

Sometimes you can't see the forest for the trees. What a perfect solution. Thank you.