VlookUp with Multiple Criteria?
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
|