OR statement producing N/A

[Milo1984]

Hi,

I am expecting the result to produce "NO APPROVAL REQUIRED", but it is coming up with N/A. is there something wrong with the formula?

the VLOOKUP result of F16 does match Q4

=IF(OR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4),"NO APPROVAL REQUIRED","")

Many thanks in advance

 

[Fluff]

One or other (or maybe both) of your Vlookups cannot find a match

 

[Milo1984]

so if one of the lookups returns an N/A will the whole formula show N/A?

 

[Fluff]

Yes, you can try wrapping them in Iferror like
=IF(OR(IFERROR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,FALSE),IFERROR(VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4,FALSE)),"NO APPROVAL REQUIRED","")