Thread: Reference different files using vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intricatefool
 
Posts: n/a
Default Reference different files using vlookup

Is there any way I can set up vlookup to reference different file names?
I have to lookup information collected from each state and I am guessing
there is some way to go about doing this. For example currently my
vlookup looks like:

" =VLOOKUP($A29,'[Report_MS.xls]Please complete'!$C$6:$D$23,C$1,FALSE)
"

I would like to be able to drag this down to reference the next state
file. Is there any way I can easily change the "MS" to the next
corresponding state?


--
intricatefool
------------------------------------------------------------------------
intricatefool's Profile: http://www.excelforum.com/member.php...o&userid=32919
View this thread: http://www.excelforum.com/showthread...hreadid=546706

Reply With QuoteReply With Quote