i have two worksheets:
sponsor and agency
agency sheet:
colA--------colB-------------colC---------
Period------week------------brand--------
1-----------1----------------CT----------
1-----------1----------------TT----------
1-----------2----------------CT----------
sponsor sheet:
colA--------colB-------------colC---------colD
Period------week------------brand--------amount
1-----------1----------------CT----------500
1-----------1----------------TT----------287
1-----------2----------------CT----------473
i need colD in agency to populate with the corresponding record - by
period week and brand in colD of sponsor sheet.
I can't put an address because they may not be in the same order.
the agency sheet has more records than the sponsor does but they would
always be sorted individually by period then by week then by brand.
--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile:
http://www.excelforum.com/member.php...o&userid=22987
View this thread:
http://www.excelforum.com/showthread...hreadid=374513