Adjusting formula to return blank with no n/a error

[snewsome]

I need help to adjust the following formula to return blank (no n/a error), please help!

=IF(VLOOKUP(D26,'DB-Lot Status'!B:H,7,FALSE)="1","M","")

 

[barry houdini]

Try using IFERROR function like this:

=IFERROR(IF(VLOOKUP(D26,'DB-Lot Status'!B:H,7,FALSE)="1","M",""),"")

 

[snewsome]

Try using IFERROR function like this:

=IFERROR(IF(VLOOKUP(D26,'DB-Lot Status'!B:H,7,FALSE)="1","M",""),"")

It's not returning anything but a blank cell even with the vlookup..?

 

[Jonmo1]

Perhaps you need to remove the quotes from the "1"
The Text String "1" is NOT the same as the Number 1

=IFERROR(IF(VLOOKUP(D26,'DB-Lot Status'!B:H,7,FALSE)=1,"M",""),"")

 

[snewsome]

Perhaps you need to remove the quotes from the "1"
The Text String "1" is NOT the same as the Number 1

=IFERROR(IF(VLOOKUP(D26,'DB-Lot Status'!B:H,7,FALSE)=1,"M",""),"")

You rock! That worked...

Now for some reason other formulas aren't functioning the way they first did as I build on the spreadsheet. The below formula ins't working how I'd hoped.

=IF(M5="9",IF(L5="M",(LEFT(H5,7))&".71020",LEFT(H5,7)&".59010"),H5&"."&E5)

If M5=9 then return 7 digits from H5 & .59010, but if an M is included in L5 then .71020. If M5 is not a 9 then return H5 a "." and data from E5...hope that makes sense. Should the formula work or am I looking at it wrong??