Indirect/Vlookup - Using a Cell reference to lookup the Array

[aldunn15]

Good Afternoon,

I have a question which i have been searching the web with sadly no luck yet.

When using Indirect within a Vlookup i want to use a dropdown to search the array as i have data in multiple places.

Currently this is what i have;

=Vlookup(A1,INDIRECT("'"A2"'&!"I2"),3,false)

Within the Cell I2 is the array Range - A2:G10

However i'm getting a REF Error

Thanking you in Advance

Alex

[Pete_UK]

Do you have the sheet name in I2? If so, you have the text string the wrong way round in the INDIRECT function. If not, then what does I2 contain?

Pete

[Pete_UK]

Sorry, I misread your post. If A2 contains the sheet name, then your formula should be:

=Vlookup(A1,INDIRECT("'"&A2&"'!"&I2),3,false)

Hope this helps.

Pete

[Glenn Kennedy]

Try this:

=VLOOKUP(A1,INDIRECT("'"&A2&"'!"&I2),3,FALSE)

next time... read the yellow banner (top) and provide us with a sample sheet. That removes ambiguity.

[aldunn15]

Guys - Thank you so much for your help and apologies next time i'll upload a sample sheet (First Time Caller)

[Glenn Kennedy]

No need to apologise!! You're new.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.