Hi there,

Im in need of help to figure out the correct excel formula that will
help to populate data from one table to the other in excel. Ive done a
Pivot from the main resource to get the results as below:

A B C
58217 Count of Pencils 22
Count of Books 8
58223 Count of Pencils 25
Count of Books 18
58234 Count of Pencils 25
Count of Books 9
58239 Count of Pencils 1
Count of Books 1
58249 Count of Pencils 18
Count of Books 10
58255 Count of Pencils 23
Count of Books 19
58263 Count of Pencils 32
Count of Books 24

Now I need to populate the Count of Pencils and Books to the IDs in the
table below:
A B C D
ID Name Num of Pencils Number of Books
58217
58223
58234
58239
58249
58255
58263

Both tables are in one same sheet.

Please help. Thanks a bunch!! :)


--
exxon99
------------------------------------------------------------------------
exxon99's Profile: http://www.excelforum.com/member.php...o&userid=34962
View this thread: http://www.excelforum.com/showthread...hreadid=546968