Hello All,


Looking for some help....please!

So I have 3 columns (A, B & C) that have all been filled from a VLOOKUP function. I would then like to use the CONCATENATE function to combine the three cells into one string(A,B,C). However, some fields in Column B & C are #N/A(due to their being no reference from the VLOOKUP), and the CONCATENATE function will return as #N/A. *FYI-Copied and pasted all as values- no more VLOOKUP formula!*

I would like to set it up so that if a cell in Column B/Column C does contain #N/A, to just insert as blank during concatenation.

Here are the three scenarios that could happen...Column A will ALWAYS have text.

1. Column A contains text, Column B Contains Text, Column C= #N/A
Output = Column A text - Column B text- Blank
2. Column A Contains Text, Column B =#N/A, Column C contains text-
Output= Column A Text - Blank - Column C Text
3. Only column A contains text, B & C = #N/A
Output= Columan A Text- Blank - Blank

I was thinking this formula, but it obviously didn't work since I am on here asking for help!..............................
=CONCATENATE(B2,"-",=IF(B2=#N/A," ",B2),"-",=IF(C2=#N/A," ",C2))


Regards,


Sam.