vlookup

Laura Bell

Hello,

I have a crew list on one sheet. I have a covid vaccination status on another sheet. I want to pull the vaccination status from the tracker into the crew list. I'm doing something wrong.

Paul Newcome

You need an INDEX/COLLECT instead.

=INDEX(COLLECT({Checkbox Column}, {First Name Column}, @cell = [First Name Column]@row, {Last Name Column}, @cell = [Last Name Column]@row), 1)