Forum Discussion
Vlookup array formula in a table
Hi, is there any possibility to use VLOOKUP and match array functions to auto-populate the table by entering a formula in H2?
In H2:
=IFERROR(INDEX($C$2:$E$5, MATCH($G2, $B$2:$B$5, 0), MATCH(H$1, $C$1:$E$1, 0)), "")
Fill down to row 3 and to the right to column J