close
can hlookup formula and vlookup formula 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: www.excelforum.com/member.php...foamp;userid=3472
View this thread: www.excelforum.com/showthread...hreadid=534471Yes.
If you post what you are trying to achieve we may be able to help.
--
Kind regards,
Niek Otten
quot;Arul Tquot; gt; wrote in message ...
| can hlookup formula and vlookup formula be used in combination
|
全站熱搜
留言列表
