VLOOKUP & table array selection

  • Thread starter Thread starter OffCoder
  • Start date Start date
O

OffCoder

I hope someone can help me. Is there a way to select the table array i
VLOOKUP from a cell reference? Cause i can't figure out how to do it.:


=VLOOKUP(A6,'MY WORKSHEET'!1:65536,27,FALSE)

Where MY WORKSHEET would be a ref from A
 
Hi
try
=VLOOKUP(A6,INDIRECT("'" & A1 & "'!1:1000"),27,FALSE)

Frank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP #REF error 3
Vlookup with a pick list for tables 1
Vlookup 2
Excel Vlookup Help 0
Some rules about Vlookup REPOSTED 6
VLOOKUP variable array references 1
VLOOKUP...have 3pm deadline but making progress almost there! 6
VBA userform Vlookup Excel 1

Back
Top