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?
I assume from your choice of functions that you are not using Excel 365? If you were, the solution might be expressed in the form
= FILTER(values, COUNTIFS(required,row_hdr))The formula, placed in the top-left cell of the intended output range, spills to provide the entire array of results without copying down or to the right.