can hlookup and vlookup be used in combination ?
 

can hlookup formula and vlookup formula be used in combination

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

can hlookup and vlookup be used in combination ?
 

Yes.
If you post what you are trying to achieve we may be able to help.

--
Kind regards,

Niek Otten

"Arul T" wrote in message ...
| can hlookup formula and vlookup formula be used in combination
|