Issue with VLOOKUP & Grid names...

**Gr44** · 10-15-2008, 05:02 AM

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!

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

**Andy Pope** · 10-15-2008, 05:16 AM

You need to use the INDIRECT function

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

**ratcat** · 10-15-2008, 05:17 AM

G'day Sean and welcome to the forum,

Try this

Please Login or Register  to view this content.

Please try it with the "" and without the ""

HTH

**Gr44** · 10-15-2008, 05:17 AM

Ahhh....

No idea what that does so I'm off to use Excel help!

Many thanks though, worked a charm!

Cheers,

Sean

**Gr44** · 10-15-2008, 05:20 AM

Thanks RatCat, AndyPope beat you to it though! ;-)

Thanks for the welcome & the fast response from both of you. Very much appriciated!

No doubt I'll ask some more noobie questions soon!

Many Thanks,

Sean