2 vlookup functions, need to replace the n/a's with blanks

[agroza85]

=IF(V3="CAC",VLOOKUP(F3,'Service List'!B3:G436,6,FALSE),VLOOKUP(F3,'Service List'!B437:G1185,6,FALSE))

these are the formulas i'm working with.

Can someone help?

[davesexcel]

=iferror((formula),"")

[agroza85]

=iferror((formula),"")

Thank you for your reply. Where do I put it? I Have 2 vlookups.

[ebworld92]

Thank you for your reply. Where do I put it? I Have 2 vlookups.

Probably nest it with both of them as VLookup will always turn up N/A if true.

=IF(V3="CAC",IFERROR(VLOOKUP(F3,'Service List'!B3:G436,6,FALSE),""),IFERROR(VLOOKUP(F3,'Service List'!B437:G1185,6,FALSE),""))

OR

=IFERROR(IF(V3="CAC",VLOOKUP(F3,'Service List'!B3:G436,6,FALSE),VLOOKUP(F3,'Service List'!B437:G1185,6,FALSE)),"") - Cleaner?