Forum Discussion
Creating an if then rule with multiple options
Hi Everyone! I am very novice in excel and trying to populate a field. I'm looking for a way to create a formula for the green column. I'd like it to populate one of the qtrly rewards fr...
HansVogelaar Thanks so much for the help!!
Here's the formula I entered, including the column numbers- i tested to see if it would go through and it didn't.. Do you know what I did wrong?
data source (sheet 2)
Enter 0 in A7 and B7 on Sheet2, and change the formula to
=MAX(VLOOKUP(I4,Sheet2!A7:C11,3),VLOOKUP(I5,Sheet2!B7:B11,2))