Formula Question

HZAR

Hi

I have the formula below. If I need to add in another status "Need Info" in the formula, how can i add in?

=IF(AND([Approval Required]@row = "Yes", [Status]@row = "Review"), VLOOKUP(CM@row, {CM Range 1}, 3, 0), VLOOKUP(Comm@row, {CM Range 1}, 2, 0))

The screenshot as attach

Screenshot 2024-05-14 162419.png

Kelly Moore

Hey @HZAR

try this:

=IF(AND([Approval Required]@row = "Yes", OR([Status]@row = "Review",[Status]@row ="Need Info")), VLOOKUP(CM@row, {CM Range 1}, 3, 0), VLOOKUP(Comm@row, {CM Range 1}, 2, 0))

Will this work for you?
Kelly

Kelly Moore

Hey @HZAR

try this:

=IF(AND([Approval Required]@row = "Yes", OR([Status]@row = "Review",[Status]@row ="Need Info")), VLOOKUP(CM@row, {CM Range 1}, 3, 0), VLOOKUP(Comm@row, {CM Range 1}, 2, 0))

Will this work for you?
Kelly

HZAR

Hi @Kelly Moore

Thanks for the advise. Really works. Awesome and really appreciate your input