Autopopulate cells based on numbers in another sheet

chanpink

New Member
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.

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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.

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!!!!!!

Replies
6
Views
437
Replies
3
Views
379
Replies
1
Views
3K
Replies
2
Views
302
Replies
4
Views
2K

1,203,506
Messages
6,055,805
Members
444,825
Latest member
aggerdanny

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back