VLOOKUP with multiple search criteria

Tracy PIneda

I am trying to do a VLOOKUP but matching multiple criteria. For example, a name and phone number need to match in the table to result in the corresponding weight of said person.

Paul Newcome

What you need in this instance is an INDEX/COLLECT.

=INDEX({Weight Column}, {Name Column}, @cell = Name@row, {Phone Number Column}, @cell = [Phone Number]@row), 1)

Tracy PIneda

That didn't work :-(

It needs to display the weight of the person if the name, phone number, and a date match.

Paul Newcome

Then you would just need to add another range/criteria set for the date.

=INDEX({Weight Column}, {Name Column}, @cell = Name@row, {Phone Number Column}, @cell = [Phone Number]@row, {Date}, @cell = Date@row), 1)