I couldn't get this to work on my Excell 2003, but maybe the conditional format is the way to go with the vlookup thing. I couldn't get it to work. but maybe its because its beta? I'm going to play with this and if I can get it i'll post it.
Also try the FIND command, if you want to make it longer you could do something like this for ALL of them
=IF(FIND("3.06 GHz",B3,1),SUM(C3*420),IF(FIND("2.8 GHz",B3,1),SUM(C3*320),and so forth LOL ))))
that would be really bad coding, but it wouldn't work, because i'm tired! so i'm gonna play with it later. let me know if you get it working before I wake up.
Later
~Dude
Hybrid Mode
