Hello,

I am trying to write an embedded IF statement that has 3 conditions but multiple acceptable options in each condition (does that make sense)? The below is an example of my formula (which works, but is cumbersome). I would like to replace all of the 'OR' statements with one formula which references a table on the 'Lookup Table' tab, rather than having to list out each cell individually. Would it be possible to do a VLOOKUP here?

=IF(AND(OR($N6='Lookup Tables'!$G$4,$N6='Lookup Tables'!$G$6),OR($H6='Lookup Tables'!$H$4,$H6='Lookup Tables'!$H$6,$H6='Lookup Tables'!$H$7),$D6='Lookup Tables'!$I$5),"X","")

Basically, what I want to say is: "If the value of N6 is in this range of cells (G4:G6), and the value of H6 is in this range of cells (H4:H6), and D6 equals Lookup Tables cell I5, then put an 'X', otherwise leave blank...

Any ideas?

Thanks in advance!!