Impossible Formula!

[Filmmaker]

What if B1 was Chevy or any other of several values? I.E.- B1 could
contain Chevy, Ford, Honda, Toyota, et al. and the formula conditioned
if b1 was Chevy for one value and all the others for another value?
Again, all this help is appreciated.

 

[Frank Kabel]

Hi
if you have that many conditions you may better use a lookup table. Try
the following:
1. Create a new worksheet (e.g. called 'lookup') which hat the
following layout:
A B C D .......
1 Chevy Ford Toyota
2 Red 1000 1500 2000
3 Orange 500 2000 100
4 Blue 1000 3000 5000
...
Create this kind of lookup table for all your conditions

2. Now on your other sheet use the following formula
=INDEX('lookup'!A1:G20,MATCH(B1,'lookup'!A1:G1,0),MATCH(A1,'lookup'!A1:
A20,0))