Share via

Name/Surname B18:B92 if match name/surname in E5:E15 points in D5:D15 copy to C18:C92

Tommie Burger 0 Reputation points
2025-03-08T11:43:28.21+00:00

I must get a formula to use in C18:C92 for the following question: I have name/surname in B18:B92 and same name/surname in E5:E15. Points in D5:D15 and this points must be copy to C18:C92

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,802 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. riny 430 Reputation points
    2025-03-08T12:31:48.7966667+00:00

    With a modern Excel version you may enter the formula below in C18 and it will spill it's results all the way down.

    =XLOOKUP(B18:B92,E5:E15,D5:D15,"")

    In an older Excel version use this in C18 and copy down.

    =IFERROR(INDEX($D$5:$D$15,MATCH(B18,$E$5:$E$15,0)),"")

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.