with nested or

  1. B

    Using IF, AND, OR and VLOOKUP in one

    Hi, Here is my problem I am trying to write 'if the value in E1 is anywhere in column T AND either R1 OR S1 is in column U then TRUE, otherwise FALSE' Now using vlookups to get the values works fine, also when i combine the IF statement with AND it works but when i try...

Some videos you may like

This Week's Hot Topics