Thread: can hlookup and vlookup be used in combination ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MattShoreson
 
Posts: n/a
Default can hlookup and vlookup be used in combination ?

use the worksheet function INDEX and combine with MATCH in this
instance.

e.g. INDEX(areaname,
match(param1,paramrange1,false),match(param2,param range2,false))


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=534471

Reply With QuoteReply With Quote