I have 4 columns of data. I am trying to connect the Scores to the idNumbers.

Two sets of data. Column A and B are idNumber and Member names.

And Column C and D are Participants and their Scores.

The Participants are Members, but not all of the Members participated.

So, need a way to connect the Scores to the idNumbers by matching or sorting the Members and Participants.

I attached a small sample. The columns are actually 100's of members and participants long.

Ultimately, to create a weekly log of active Member's Scores.

enter image description here


1 Answer 1


Put this vlookup() formula in row 1 of a free column:

=arrayformula( iferror( vlookup(B1:B, C1:D, columns(C1:D), false) ) )


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.