Remove 0 value cells from Vlookup results from two sheets.. HELP please

[Boubiche]

Good morning guys,


i am in dire need of your expertise.. i am doing a Vlookup between two different sheets.. it works no problem...
=IFERROR(VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0),"OOPS!"))


But u would to remove the cells that display a 0 value
=IFERROR(IF(LEN(VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0))=0,"",VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0)),"")


but it doesn’t work...
What am i doing wrong.. please help.. Excel states i have entered too little arguments!! i am at lost with my limited knowledge of Excel..

thanks for your help

 

[sheetspread]

=if(IFERROR(VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0),"OOPS!"))=0,"",IFERROR(VLOOKUP($A2,'RAW Certus'!A:O,11,0),IFERROR(VLOOKUP(A2,'RAW SF'!A:Z,20,0),"OOPS!")))

 

[Boubiche]

You, my friend are amazing!! Lesson learned!!! thank you so much!!!