eramirez148
Board Regular
- Joined
- Aug 17, 2022
- Messages
- 54
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- MacOS
Is there a formula that can give me the following results in column C in table 1. Basically I wanted table 1 column c to look for the description from column a table 1 in table 2 and trace column B and add that number to column B from tab;e 1
Example
Table 1 "A2" Chiller Fresh the results in column C "listing" is 7/1/2023 because it is finding in table two column B that listing is -25 so column C in table 1 takes into account column "B" 7/26/2023 and deducts -25 for chiller/fresh.
Table 1
Table 2
Example
Table 1 "A2" Chiller Fresh the results in column C "listing" is 7/1/2023 because it is finding in table two column B that listing is -25 so column C in table 1 takes into account column "B" 7/26/2023 and deducts -25 for chiller/fresh.
Table 1
A | B | C | |
1 | Listing | ||
2 | Chiller/Fresh | 7/26/2023 | 7/1/2023 |
3 | Freezer | 7/26/2023 | 6/28/2023 |
4 | Ambient | 7/26/2023 | 7/2/2023 |
Table 2
A | B | C | |
1 | Listing | Master Data Check Start | |
2 | Chiller/Fresh | -25 | -27 |
3 | Freezer | -28 | -27 |
4 | Ambient | -24 | -27 |