Impossible Formula!
 

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.


--
Filmmaker
------------------------------------------------------------------------
Filmmaker's Profile: http://www.excelforum.com/member.php...o&userid=16266
View this thread: http://www.excelforum.com/showthread...hreadid=276685

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))

--
Regards
Frank Kabel
Frankfurt, Germany

"Filmmaker" schrieb im
Newsbeitrag ...

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.


--
Filmmaker
---------------------------------------------------------------------
---
Filmmaker's Profile:
http://www.excelforum.com/member.php...o&userid=16266
View this thread:
http://www.excelforum.com/showthread...hreadid=276685