I am just starting to learn about Excel and am working on a spreadsheet, the problem is if the Vlook function doesnt provide a match from B17 and Sheet1!E:I,5,0, #N/A appears which causes an error message in another cell. How do you go about changing the code so it does the same calculation but if there is no match the cell remains empty. Any help appreciated



=IF($G$4>Sheet1!$C$2,"",IF(VLOOKUP(B17,Sheet1!E:I,5,0)="","",VLOOKUP(B17,Sheet1!E:I,5,0)))