Multiple vlookups in single cell

[BRUD1]

Hi, New to this forum, so go easy.

I have managed to return 4 separate values using 4 vlookups on different lines in a single cell.
The purpose would be for these formula to run the entire year and show dates from the 4 other cells in the corresponding months accordingly.
However when one of the dates is not in range of Mar -18 it returns #N/A. How to return a blank for Non Mar 18 dates and still show those dates that are in Mar 18.

=TEXT(VLOOKUP($E$9,Table9[Mar-18],1,FALSE), "dd/mm")& "
" &TEXT(VLOOKUP($F$9,Table9[Mar-18],1,FALSE), "dd/mm")& "
" &TEXT(VLOOKUP($G$9,Table9[Mar-18],1,FALSE), "dd/mm")& "
" &TEXT(VLOOKUP($F$9,Table9[Mar-18],1,FALSE), "dd/mm")

Cheers

 

[Aladin Akyurek]

You can try...

=IFERROR(TEXT(VLOOKUP($E$9,Table9[Mar-18],1,FALSE), "dd/mm"),"")& "
" &IFERROR(TEXT(VLOOKUP($F$9,Table9[Mar-18],1,FALSE), "dd/mm"),"")& "
" &IFERROR(TEXT(VLOOKUP($G$9,Table9[Mar-18],1,FALSE), "dd/mm"),"")& "
" &IFERROR(TEXT(VLOOKUP($F$9,Table9[Mar-18],1,FALSE), "dd/mm"),"")

 

[BRUD1]

Awesome, thanks very much'

 

[Aladin Akyurek]

Awesome, thanks very much'

You are welcome.

 

[BRUD1]

I have another question regarding the above Vlookup in single cell. To distinguish what each value represents, I'm trying to workout if I can conditionally format each of the 4 values into different colors. Not sure if its possible.

 

[Aladin Akyurek]

I have another question regarding the above Vlookup in single cell. To distinguish what each value represents, I'm trying to workout if I can conditionally format each of the 4 values into different colors. Not sure if its possible.

I'm afraid this is not possible with formulas or format cells. I don't think such is possible with conditional formatting either.

 

[BRUD1]

Thanks for the reply. Much appreciated