Hi all - would be grateful for a little help.

Wanting to write an IF statement which brings back a result based on two conditions but my knowledge is holding me back.

=IF(r2=”Purple”and(t2=”Green”or”Orange”),Vegetables,””))

Where Vegetables is a Range.

Actually wanting to nest it in data validation to bring back an appropriate drop down list.

Hoping you can help. Many thanks.