Forum Discussion
How to set conditional values of a cell base on the value of another cell
I'm a very basic user of excel so please forgive my ignorance. I'm attempting to assign a cell a specific value base on certain conditions of another cells value. I'm inputing score cards for my g...
=VLOOKUP(C2-B2,$G$2:$I$7,3,FALSE)=VLOOKUP(C2-B2,$G$2:$I$7,2,FALSE)An alternative could be a reference table along with VLOOKUP formulas. The formulas are in cells D2 and E2 and filled down.