Thread: Variable Table Array in Lookup Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
matt_the_brum matt_the_brum is offline
external usenet poster
  
Posts: 1
Default Variable Table Array in Lookup Function

Thanks. Had a look but not having much luck with the INDIRECT
function.

All I want is the Red writing in

=HLOOKUP(A10,Labour!$B$1:$L$2,2,FALSE),FALSE)

to equal whatever is in say cell A3.


--
matt_the_brum
------------------------------------------------------------------------
matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751
View this thread: http://www.excelforum.com/showthread...hreadid=568240

Reply With QuoteReply With Quote