Idk what I'm doing wrong here...
(Note: These are aj pet prices, not cs pet prices. Leaving this here so people know I'm not making this to trade between cs and aj)
Codes are:
Cost - =IF(A3=G2:G21, 2,3)
With Accessories - =SUM(A3,1)
Currently In Stores? - =IF(A3=G2:G21, "Yes","No")
I'm trying to make it so the cost for in-store pets costs 2 and out-of-store pets cost 3, with accessories is one extra. I'm trying to use the IF function to refer it to the "In Stores" table. And if the pet is in stores then it will say "Yes" under the Currently In Stores column.