CONCATENATE but Eliminate the Error Cells

[KSQUARE2K6]

Hi,

I have 3 cells which is having vlookup values, Few of the cells are contains the Value and few of thems are having #N/A value because of Velookup result, so I want to concatenate these three cells and get the value in the fourth cell.

Please help me to solve my issue

Regards,
KK

[azumi]

Could U Pls upload your dummy workbook?

[KSQUARE2K6]

Hi,

Here I have made the Dummy data which will help you to understand my requirment.

Q cellis the required output

M, N & o cells need to be concatenate

Please let me know, if you have any questions from the attached sheet

Regards,
KK

[benishiryo]

hi KK. a simple way is to use IFERROR for your VLOOKUP formulas so that you don't get 0 or NA
=IFERROR(VLOOKUP(L2,$A$2:$B$6,2,FALSE),"")

then just do a simple:
=M2&N2&O2

[KSQUARE2K6]

I got the 0 when applying the formula in the N cell. Please suggest me

Regards,
KK

[benishiryo]

my bad. add a &"" to the VLOOKUP too
=IFERROR(VLOOKUP(L2,$A$2:$B$6,2,FALSE)&"","")

[KSQUARE2K6]

Thanks, It is working fine..

Regards,
KK