Garadactyl
New Member
- Joined
- Dec 16, 2013
- Messages
- 4
It may seem a bit confusing from the title, but that is because I am a bit confused by it as well.
I have a table that has 3 columns.
A. Date Ordered
B. Tooling ID
C. Cost
<tbody>
</tbody>
This table is filled out when a Tool is purchased. On the current sheet I have over 700 entries.
We just recieved a new program that we will order our tooling through instead of doing it over the phone, and will track all this information for us. The only thing, is we have to input the most recent prices for the tooling in ourselves, which we currently only have in the excel sheet.
What I want to do, is create another table that has just the Tooling ID and the Cost. But I want a formula in the cost column that will search the Purchase order Log for the Tooling ID, and return the cost from the row that has the most recent date in it. So for example, If the first Tooling ID on the list is 12341234, then it will look in the above table, find the 3 values "12341234" and see that $250.00 is the most recent, and place that value in.
This way I can just import the new excel sheet into the program. If anyone has a formula that will do this for me, or even a quick macro, please let me know. If I confused you at all, please ask me what i meant, this is a huge project for me, and if I do it by hand while responsible for all my other tasks, this could take me weeks. I want to have it done by the end of this week for the boss.
I have a table that has 3 columns.
A. Date Ordered
B. Tooling ID
C. Cost
12/19/12 | 12341234 | $200.00 |
1/20/13 | 43214321 | $150.00 |
3/23/13 | 56785678 | $1000.00 |
5/25/13 | 12341234 | $238.00 |
9/28/13 | 12341234 | $250.00 |
<tbody>
</tbody>
This table is filled out when a Tool is purchased. On the current sheet I have over 700 entries.
We just recieved a new program that we will order our tooling through instead of doing it over the phone, and will track all this information for us. The only thing, is we have to input the most recent prices for the tooling in ourselves, which we currently only have in the excel sheet.
What I want to do, is create another table that has just the Tooling ID and the Cost. But I want a formula in the cost column that will search the Purchase order Log for the Tooling ID, and return the cost from the row that has the most recent date in it. So for example, If the first Tooling ID on the list is 12341234, then it will look in the above table, find the 3 values "12341234" and see that $250.00 is the most recent, and place that value in.
This way I can just import the new excel sheet into the program. If anyone has a formula that will do this for me, or even a quick macro, please let me know. If I confused you at all, please ask me what i meant, this is a huge project for me, and if I do it by hand while responsible for all my other tasks, this could take me weeks. I want to have it done by the end of this week for the boss.
Last edited: