Forum Discussion
Referencing text in a cell to multiple another cell
Hello all, I am fairly new to formulas in excel and was wondering if there is a formula that I can put in F14 that will reference the text in G14, "Lost", and then take the value of E14 and multipl...
I apologize for all the questions.
Is there a way to combine this formula from =F12*10*(H12="Win") to =F12*10*(H12="5/5 Win") =F12*2*(H12="4/5 Win") =F12*0.4*(H12="3/5 Win") all in the same cell?
I tried a handful but I cant seem to figure it out.
emligh It's not going to be pretty, but if you only have these three option you could use LOOKUP like this:
=F12*LOOKUP(H12,{"3/5 Win","4/5 Win","5/5 Win"},{0.4,2,10})