One way,

=INDEX(First_field,MATCH(1,(A1:A100=1st_variable)* (B1:B100=2nd_variable)*(C1:C100=3rd_variable)*(D1: D100=4th_variable)*(E1:E100=5th_variable)*(F1:F100 =6th_variable),0))

entered with ctrl + shift & enter, then you change to the second field with
the rest of the formula the same. If the values that you want to return are
numeric you can use sumproduct

=SUMPRODUCT(--(A1:A100=1st_variable),--(B1:B100=2nd_variable),
-- etc,First_field)


Regards,

Peo Sjoblom

"Arturo" wrote:

Table Range A1:K100
Variables get passed to 6 cells out side of table.
I want returned the remaining 5 fields associated with that record.
Filtering is not an option.
I tried concatenating the 6 variables to use VLookup €“ does not work.
What are the formula or function options available to me?

Sincerely,
Arturo