Searching for a "phrase" in a cell.
This question is hard to word. I have 2 sheets, the first is how much money we think we spent, the second is how much money we actually spent. There are over 100 rows in each sheet. Every day, I must match up each sheet to verify that billing was done correctly.
Items in the first sheet list the code for the item only, example:
- Column A lists the common codes "1425"
- Column B lists amount spent on item "8.67"
Items in the second sheet list more information, example:
- Column A lists; Common code, Name, Bar code "1425 Fruit Loops 13467984"
- column B lists amount spent on item "8.67"
When all of the items match up, it's easy enough to simply filter and have a formula to add/subtract from Column B. the issue is when one of the sheets is missing an item or has an extra one. Is there a formula that simply searches a column for the first four digits listed in column A, then add/subtract from the next cell over in column B?
|