VLookup looking up two different values

[Sean15]

Hello:

This VLookup formula returns #NA if value in C194 and P194 is not found. Can you rewrite the formula to return a blank cell if the two lookup values are not found?

=IFERROR(VLOOKUP(C194,'lookup values'!$A$2:$B$27,2,0), VLOOKUP(P194,'lookup values'!$A$2:$B$27,2,0))

Regards
Sean

 

[6StringJazzer]

=IFERROR(IFERROR(VLOOKUP(C194,'lookup values'!$A$2:$B$27,2,0), VLOOKUP(P194,'lookup values'!$A$2:$B$27,2,0)), "")

 

[Sergius]

Something like this

=IFERROR(AND(VLOOKUP(C194;'lookup values'!A2:B27;2;0);VLOOKUP(P194;'lookup values'!A2:B27;2;0);"YES";"");" ")