Vlookup and Hlookup in a forumla

G

Gustav

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

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))
 
Top