This is going to be long and tedious, or I am just simple minded. I would like to have a database of information (Control) on one sheet, and import data on another sheet, and have a formula compare that to the control and if it finds a similarity I need it to tell me how much money is invovled.
This would be me control sheet with prices (Two Columns)
<colgroup><col><col></colgroup><tbody>
</tbody>
and I would like to import information like this (3 columns)
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I would like a cell to scan for certain "Codes" like 420782, and 425137, and sum the total dollars that it returns. I don't know if that is one formula or if it is going to have to be a singular formula for each "code". There are going to be multiple codes for each import, and I would like to have it bounce off my control sheet. Thus I could ammend my control sheet from time to time when the codes change (which they do from year to year) My imports are going to be on a new sheet, but i could have all of them bounce off the "Codes" sheet, but it will all be in one book. I hope I am explaining this ok
Any thoughts on how to do this?
Thanks in advanced,
Seth
This would be me control sheet with prices (Two Columns)
722988- Large Color Display Combine | 2855 |
420782- AutoGuide ready w/ GPS mount | 4210 |
425137- NavII | 4170 |
425510- 372 waas | 2502 |
425504- 372 Omni | 4430 |
712635- desktop software | 639 |
722611- yield and moisture logging | 3177 |
415149- AG manual | 0 |
<colgroup><col><col></colgroup><tbody>
</tbody>
and I would like to import information like this (3 columns)
VERSION | HVYDUTY | HEAVY-DUTY |
AUTOGUIDANCE | 420782 | FACTORY GUIDANCE READY |
BACK-UP ALARM | XT5201X | STANDARD LESS BACKUP ALARM |
BALLAST PACKAGE | 462716 | FRONT WEIGHT 462716 |
COMPRESSION ENGINE | XT1933X | LESS COMPRESSION BRAKE |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I would like a cell to scan for certain "Codes" like 420782, and 425137, and sum the total dollars that it returns. I don't know if that is one formula or if it is going to have to be a singular formula for each "code". There are going to be multiple codes for each import, and I would like to have it bounce off my control sheet. Thus I could ammend my control sheet from time to time when the codes change (which they do from year to year) My imports are going to be on a new sheet, but i could have all of them bounce off the "Codes" sheet, but it will all be in one book. I hope I am explaining this ok
Any thoughts on how to do this?
Thanks in advanced,
Seth