Help needed in using a concatenated string for VLOOKUP table_array

[niranjanbt]

Hi,

Lets say I have a string LC1!E6:LC1!J243 resulting from concatenation in cell A1.
I want to use this string as the table array in VLOOKUP function, how do I do that?

VLOOKUP(13,????,2,FALSE)
I am stuck here for almost a day now. Any help will be appreciated.

Thanks.

[6StringJazzer]

Welcome to the Forum!

Let me know if this works for you:

Please Login or Register  to view this content.

[AlKey]

I can assume that LC! is a sheet in your workbook

Try this:

=VLOOKUP(13,INDIRECT("LC!E6:J243"),2,0)

[niranjanbt]

Thanks a lot guys!! That solves my problem...
The issue was in the concatenated string itself.It should have been LC!E6:J243 and not LC1!E6:LC1!J243.

[AlKey]

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).