Autopopulate cells based on numbers in another sheet

[chanpink]

I'm looking to autopopulate a list of numbers that match numbers in a different worksheet:

Column A has a list of center numbers: Some are listed multiple times

TABLE A.

Center no.	No. of Comments
106	need to autopopulate from Table B.
106
106
106
106
108
108
108

<tbody>
</tbody>

Worksheet 2 has a list of center numbers with the number of comments each center received (done via. pivot table)

TABLE B.

Center no.	No. of Comments
106	35
108	42
113	12

<tbody>
</tbody>

I'd like to autopopulate the list of multiple center numbers with the no. of comments in for TABLE A.

 

[elmer007]

I may not understand the question correctly, but it looks like vlookup will do the trick.

In cell B2 of Table A, put the formula: =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
This formula assumes that your pivot table is on a sheet called "sheet2" (change this part of the formula if it isn't) and that the pivot table has "Center no." and "No. of Comments" in columns A and B of sheet2.

Copy this formula down the table.

Let me know if this doesn't work or if you have any questions.

 

[chanpink]

I may not understand the question correctly, but it looks like vlookup will do the trick.

In cell B2 of Table A, put the formula: =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
This formula assumes that your pivot table is on a sheet called "sheet2" (change this part of the formula if it isn't) and that the pivot table has "Center no." and "No. of Comments" in columns A and B of sheet2.

Copy this formula down the table.

Let me know if this doesn't work or if you have any questions.

THAT WORKED!!! Thank you so much for your quick help!!!!!!