If statement with VLOOKUP

[holykimura]

Hi could any one tell me what is wrong with the below:

=IFERROR(IF(AND(U5="",U5<>"A"),(VLOOKUP(T5,Belt,2,FALSE)-VLOOKUP(D5,Belt,2,FALSE)),(VLOOKUP(U5,Belt,2,FALSE)-VLOOKUP(D5,Belt,2,FALSE))),"Absent")

I want it to look at Cell U5 to see if it is blank or contains the letter A and if so carry out either of the two VLOOKUP calculations, where the first Vlookup calculation is executed if both of the conditions in the IF statement are met otherwise carry out the second calculation. However it only seems to work if cell U5 contains the letter A but not if it is blank. What am I doing wrong?

Thanks in advance.

 

[steve the fish]

Your first vlookup will only ever trigger if U5 is blank. Sounds like you need an OR rather than an AND.

 

[holykimura]

Your first vlookup will only ever trigger if U5 is blank. Sounds like you need an OR rather than an AND.

Hi thanks for your help i've just tried the OR and it works if i use "=" for both instead of "<>" I think i'd confused myself lol.