Vlookup error

[Nanogirl21]

I am using the below formula to populate a cell based on dates from a different worksheet. Everything is working properly, but I am getting error #N/A when the date is not available. How can I modify the formula to return a blank cell (no text) when an error #N/A is returned?

=IF(ISERROR(VLOOKUP(F10,Dates!$A:$I,2,FALSE))," ",VLOOKUP(F10,Dates!$A:$I,2,FALSE))&CHAR(10)&VLOOKUP(F10,Dates!$A:$I,3,FALSE)&CHAR(10)&VLOOKUP(F10,Dates!$A:$I,7,FALSE)

 

[Nanogirl21]

Try something like this

=IF(ISNUMBER(MATCH(D5,Events!B:B,0)),"rest of the formula","")

M.

I tried this and it is saying that i eneted too many arugments for the function.


Since I could not get it to work. I decieved to just use conditional formatting to turn the cell that contains an error to white.

 

[Marcelo Branco]

Show us the whole formula you tried

M.

 

[Marcelo Branco]

Maybe this...

=IF(ISNUMBER(MATCH(D5,Events!B:B,0)),IF(VLOOKUP(D5,Events!B:Z,9,FALSE)="yes",VLOOKUP(D5,Events!$B:$Z,3,FALSE)&CHAR(10)&VLOOKUP(D5,Events!$B:$Z,2,FALSE)&CHAR(10)&VLOOKUP(D5,Events!$B:$Z,6,FALSE),""),"")

Hope this helps

M.