Returning an array of lookup values from an input array, rather than single value

if i understand your requirement correctly (and if i do not, my apologies):

if you weren't able to get a proper result out of the INDEX function, it is due to the fact that your named_ranges were slightly askew. in lookup_table, cell J3 was included, but in lookup_row, it was not.

see attached: