Hi
try something like the following array formula (entered with
CTRL+SHIFT+ENTER)
=INDEX(K1:K100,MATCH(1,(A1:A100="value1")*(B1:B100 ="value2)*...*(F1:F100="value6"),0))

--
Regards
Frank Kabel
Frankfurt, Germany
"Arturo" schrieb im Newsbeitrag
...
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