Combine Formulas - Vlookup: Blanks, Errors, Values

Hi yall,

I'm trying to combine two formulas together to display the data as such.. (if vlookup cell is blank -> display blank) (if vlookup cell is populated -> display populated value) (if vlookup value comes up error -> display blank)

I managed to comeup with the below formulas which the first one fixes my first two problems and the second fixes my third problem. But can't seem to figure out how to combine them all together.

=IF(VLOOKUP(B4,'Time'!$B$5:$FH$26,39,FALSE)="","N/A",VLOOKUP(AUTO!B4,'Time'!$B$5:$FH$26,39,FALSE))

=IFERROR(VLOOKUP(B4,'Time'!$B$5:$FH$26,40,FALSE),"")

Anyone can help me?

Just combine them:
=IFERROR(IF(VLOOKUP(B4,'Time'!$B$5:$FH$26,39,FALSE)="","N/A",VLOOKUP(AUTO!B4,'Time'!$B$5:$FH$26,39,FALSE)),"")

Oh my gosh! Thank you minnesotaart I'm having trouble with how that worked but it got the job done

Fdibbins I made them formulas in two different columns when I was working out my solutions and forgot to change them to match so thanks for pointing that out.

Think of "IFERROR" as a "wrapper". If a formula kinda works but sometimes gives you an error that you wish would just go away, then just "wrap" that formula with an IFERROR function and force it to what you want (in your case, a blank).