Issue with VLOOKUP & Grid names...

Hi,

I'm having an issue with VLOOKUP, I'll keep it short as I don't think I need loads of details because I have done some troubleshooting and believe got to the cause of the problem... I just don't know how to fix it!

=VLOOKUP(D11,SunGrid,2,0)

The following code works correctly and finds the contains of D11 in the 'SunGrid'.

However I wish the 'Sun' to be a variable and get its contains from another cell (C11)... so I'm using this:

=VLOOKUP(D11,C11&"Grid",2,0)

The contains of C11 is 'Sun' no spaces or strange formatting. I've also tried putting brackets around (C11 & "Grid"). Using the 'Show calculation steps' the end result looks exactly the same as the formula that works above... so I don't understand what the problem is!

The error I recieve on the above formula is '#VALUE!'

Anyone able to assist me?

Many Thanks,

Sean