Removing #N/A from Cell after calculation

[WWST]

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)))

[aabbey]

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


Try that

You may need another bracket before the comma at the end.

[WWST]

Thanks aabbey for the help. Its working correctly now.

[aabbey]

Thanks aabbey for the help. Its working correctly now.

If it satisfied your requirement please give a reputation point. I only ask because it will be my first.

[WWST]

If it satisfied your requirement please give a reputation point. I only ask because it will be my first.

Just added it for you.

[AliGW]

It has been brought to our notice that you have cross-posted this query on another forum. Our rules require you to disclose this before you can get help here, so please provide the missing link to that other forum.

No further help, please, until the link has been provided.

Our forum rules are here: https://www.excelforum.com/forum-rul...rum-rules.html

[WWST]

I posted on 2 forums incase I didnt get a reply on one of the forums. I wont cross post again.

[Pepe Le Mokko]

Please post the link to your other post as requested and read this to understand why