can hlookup formula and vlookup formula be used in combination
M MattShoreson Apr 20, 2006 #2 use the worksheet function INDEX and combine with MATCH in thi instance. e.g. INDEX(areaname match(param1,paramrange1,false),match(param2,paramrange2,false)
use the worksheet function INDEX and combine with MATCH in thi instance. e.g. INDEX(areaname match(param1,paramrange1,false),match(param2,paramrange2,false)
N Niek Otten Apr 20, 2006 #3 Yes. If you post what you are trying to achieve we may be able to help. -- Kind regards, Niek Otten | can hlookup formula and vlookup formula be used in combination |
Yes. If you post what you are trying to achieve we may be able to help. -- Kind regards, Niek Otten | can hlookup formula and vlookup formula be used in combination |
