I had written what is presumably a very basic formula in that im sure there is a much easier way to do this but I have come across a problem. The formula below was working fine until i tried to add a further if to the statement
and got a forumla error message pop up on the word CONCATENATE on the first part of the second statement. I couldnt see how this differed to the previous and so can only assume there is a limit to the number eith of CONCATENATES you can have in a statement or the number of IFS you can nest within an original. Any help would be appreciated.
The Statemenet is intended to bring together a string from once cell with a number stored in another cell
the reason there is no equals on the second function is that I explained that it was to be put into the first function, but at the point of the second function it error, i split it into two to be a bit more helpful sorry, i know about the end parenthesys also, but i had just copied and pasted something that I had taken out from inside the original statement sorry.
With regards to the error itself its just the bog standar microsoft error to say that there has been an error in the formula with no basic description (good old helpful MS)
Sorry Colin, my mistake, i saw your code and didnt really think much of it.
I put that into my spreadsheet and that does exactly what I wanted to after I changed the value so that the index went from D41:O41. Thank you very much for your help, its now up to me to go and read up on Index as it seems very useful.