G Gustav Jul 26, 2004 #1 Can Vlookup and Hlookup be used at the same time? For example object an year in a pivot table! Thank you Gusta
Can Vlookup and Hlookup be used at the same time? For example object an year in a pivot table! Thank you Gusta
F Frank Kabel Jul 26, 2004 #2 Hi probably better to use INDEX in combination with MATCH. e.g. something like =INDEX(A1:F10,MATCH(row_value,A1:A10,0),MATCH(column_value,A1:F1,0))
Hi probably better to use INDEX in combination with MATCH. e.g. something like =INDEX(A1:F10,MATCH(row_value,A1:A10,0),MATCH(column_value,A1:F1,0))
