Nowherefast
New Member
- Joined
- May 18, 2009
- Messages
- 23
Hello:
I've been trying to create a formula to get the following info but have not had much luck.
I have 2 files and I need to populate the promo price from one file to another based on matching of the item number and then date range
See example below
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody>
</tbody>
I've been trying to create a formula to get the following info but have not had much luck.
I have 2 files and I need to populate the promo price from one file to another based on matching of the item number and then date range
See example below
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
So I need to populate "Get promo price". In the example, for item 1123, it would be $15 and then for ITem 5665 it would be "null" Hope I make sense? Thank you. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody>
</tbody>