Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can hlookup and vlookup be used in combination ?
can hlookup formula and vlookup formula be used in combination
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
VLookup & HLookup | Excel Discussion (Misc queries) | |||
How do I use Vlookup or Hlookup? | Excel Discussion (Misc queries) | |||
Combination of H & Vlookup?? | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |