Spreadsheet: 767188d1644330563-offset-function-with-more-than-one-condition-offset-formula-ans
Sheet: Sheet1

 |  | Car Make | Value for input | 2022 | 2023 | 2024
 |  | Ferrari | Total Value | 4728917 | 7966899 | 9857494 |  | E5:g5 converted text to numbers
 |  | Ferrari | Market Value in USD
 |  | Ferrari | FX | 1.2 | 1.4 | 1.6
 |  | Honda | Total Value | 1692365 | 9617768 | 6604971
 |  | Honda | Market Value in EUR
 |  | Honda | FX | 1.2 | 1.4 | 1.6
 |  | SAAB | Total Value | 4529729 | 3818089 | 2181878
 |  | SAAB | Market Value in USD
 |  | SAAB | FX | 1.2 | 1.4 | 1.6
 |  | [NAME] | Total Value | 4803648 | 1099371 | 5990138
 |  | [NAME] | Market Value in EUR
 |  | [NAME] | FX | 1.2 | 1.4 | 1.6
 |  | Ferrari | Total Value | 9320970 | 5385374 | 3568385
 |  | Ferrari | Market Value in USD
 |  | Ferrari | FX | 1.2 | 1.4 | 1.6
 |  | Honda | Total Value | 6990859 | 1323570 | 2943916
 |  | Honda | Market Value in EUR
 |  | Honda | FX | 1.6 | 1.8 | 2
 |  | SAAB | Total Value | 7109729 | 9675008 | 8204210
 |  | SAAB | Market Value in USD
 |  | SAAB | FX | 1.2 | 1.4 | 1.6
 |  | BMW | Total Value | 7723723 | 9756889 | 7871648
 |  | BMW | Market Value in EUR
 |  | BMW | FX | 1.6 | 1.8 | 2
 |  | Honda | Total Value | 4877000 | 7895078 | 1017063
 |  | Honda | Market Value in USD
 |  | Honda | FX | 1.2 | 1.4 | 1.6
 |  | SAAB | Total Value | 3499048 | 8633655 | 2228081
 |  | SAAB | Market Value in EUR
 |  | SAAB | FX | 1.6 | 1.8 | 2
 |  | [NAME] | Total Value | 7397091 | 5356504 | 8642072
 |  | [NAME] | Market Value in USD
 |  | [NAME] | FX | 1.2 | 1.4 | 1.6
 |  | Ferrari | Total Value | 6318043 | 2476149 | 9461040
 |  | Ferrari | Market Value in EUR
 |  | Ferrari | FX | 1.6 | 1.8 | 2
 |  | Honda | Total Value | 5346793 | 1048614 | 6578863
 |  | Honda | Market Value in USD
 |  | Honda | FX | 1.2 | 1.4 | 1.6
 |  | SAAB | Total Value | 3880552 | 9810827 | 3409679
 |  | SAAB | Market Value in EUR
 |  | SAAB | FX | 1.6 | 1.8 | 2
 |  | BMW | Total Value | 1433311 | 1328926 | 3212127
 |  | BMW | Market Value in USD
 |  | BMW | FX | 1.2 | 1.4 | 1.6
 |  | Ferrari | Total Value | 9272177 | 4506330 | 3318182
 |  | Ferrari | Market Value in USD
 |  | Ferrari | FX | 1.2 | 1.4 | 1.6
 |  | Honda | Total Value | 3301937 | 6623156 | 1171355
 |  | Honda | Market Value in EUR
 |  | Honda | FX | 1.6 | 1.8 | 2
 |  | SAAB | Total Value | 9817276 | 1003068 | 9954274
 |  | SAAB | Market Value in USD
 |  | SAAB | FX | 1.2 | 1.4 | 1.6
 |  | Ferrari | Total Value | 8810449 | 8870917 | 1185859
 |  | Ferrari | Market Value in EUR
 |  | Ferrari | FX | 1.6 | 1.8 | 2
 |  | SAAB | Total Value | 3371402 | 6534760 | 7574303
 |  | SAAB | Market Value in USD
 |  | SAAB | FX | 1.2 | 1.4 | 1.6
 |  | Ferrari | Total Value | 3032262 | 6189863 | 4555008
 |  | Ferrari | Market Value in EUR
 |  | Ferrari | FX | 1.6 | 1.8 | 2
 |  | Honda | Total Value | 4139079 | 7595840 | 7643880
 |  | Honda | Market Value in USD
 |  | Honda | FX | 1.2 | 1.4 | 1.6
 |  | SAAB | Total Value | 5503263 | 3206401 | 3510519
 |  | SAAB | Market Value in EUR
 |  | SAAB | FX | 1.6 | 1.8 | 2
 |  | Ferrari | Total Value | 9207201 | 4803399 | 5811955
 |  | Ferrari | Market Value in USD
 |  | Ferrari | FX | 1.2 | 1.4 | 1.6
 |  | Honda | Total Value | 9411953 | 9526790 | 8904592
 |  | Honda | Market Value in EUR
 |  | Honda | FX | 1.6 | 1.8 | 2
 |  | SAAB | Total Value | 1332055 | 9977874 | 4010217
 |  | SAAB | Market Value in USD
 |  | SAAB | FX | 1.2 | 1.4 | 1.6