Thread: Referencing a cell when using VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SandyUK[_8_] SandyUK[_8_] is offline
external usenet poster
  
Posts: 1
Default Referencing a cell when using VLOOKUP

Hello all

Does anybody know how i can replace WE 08 27 05 in the table_array part
of the formula below with a reference to a cell?

The idea is that I don't have to manually update the links everytime i
want to look at a different week just the relevant cell.

=VLOOKUP(D2,'I:\Costs\WE actuals\Date Format MMDDYY\[WE 08 27
05.xls]Customer'!$1:$65536,5,FALSE)

Regards

Adrian


--
SandyUK
------------------------------------------------------------------------
SandyUK's Profile: http://www.excelforum.com/member.php...o&userid=17487
View this thread: http://www.excelforum.com/showthread...hreadid=477505

Reply With QuoteReply With Quote