Thread: Vlookup , Referencing a cell to refence table array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Vlookup , Referencing a cell to refence table array
I was able to get something like this up:
=VLOOKUP(A1,one!$1:$65536,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"seans" wrote:
I ave multiple worksheet named one, two, three, four etc. In the worksheet
with the vlookup I need to be able to get the value in A1 say 'one' to
populate the table_array. It needs to say 'one'!$1:65536, All I can get it
to do is A1!$1:!65536.
Reply With QuoteReply With Quote