Removing #N/A from Cell after calculation

[stc60]

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

 

[Ramballah]

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

try editting the "" to " " because this "" means nothing. if theres nothing to answer it will add their own answer. " " this just means if theres a space, or give it a space. im not sure if this is what your looking for though because your question is kinda vague.

 

[sandy666]

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

 

[Fluff]

Hi & welcome to MrExcel
How about
=IFERROR(IF($G$4>Sheet1!$C$2,"",VLOOKUP(B17,Sheet1!E:I,5,0)),"")

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ge...-from-cell-after-calculation.html#post5029661

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[stc60]

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