LUIS FREUND
asked on
If Statement with multiple criterias
Looking for a formula to get me a name based on a value of a cell.
for example if the value is:
On column A - GREATER THAN $35,000 AND LESS THAN $249,999 then the name "Joann" would be placed on column B.
On column A - GREATER THAN $250,000 AND LESS THAN $499,999 then the name "Mike" would be placed on column B.
On column A - GREATER THAN $500,000 then the name "Tome" would be placed on column B.
See Attachment for example.
C--Users-lfreund-Documents-EE-IF-ST.xlsx
for example if the value is:
On column A - GREATER THAN $35,000 AND LESS THAN $249,999 then the name "Joann" would be placed on column B.
On column A - GREATER THAN $250,000 AND LESS THAN $499,999 then the name "Mike" would be placed on column B.
On column A - GREATER THAN $500,000 then the name "Tome" would be placed on column B.
See Attachment for example.
C--Users-lfreund-Documents-EE-IF-ST.xlsx
Try this formula in B2, and copy down as needed.
=IF(A2>500000,"Tome",IF(A2>250000,"Mike",IF(A2>35000,"Joann","")))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I show both INDEX & MATCH and VLOOKUP formulas in the attached file
lfreund-Documents-EE-IF-ST.xlsx
lfreund-Documents-EE-IF-ST.xlsx
ASKER
Thank you everyone for the quick responses! You guys are amazing!
Open in new window