I have tried looking for this answer, but with no joy.

I have two columns with IDs Columns A and B, and in Column C are the Count totals of Column B. What I need to do is find the match of Column B to Column A, then return in Column D the values of C, but in line with the row of Column A.

May be easier to show a picture:

Any help would be amazing! Thank you in advance.

CodePudding user response：

You may want to XLOOKUP the respective row value of column A with column B to return the related value from column C