Concatenate cells in 3 columns if value in question is found in another column

**drgkt** · 02-13-2017, 10:27 AM

Hi

In j79 I need to concatenate Description, amount and method as shown.

I wonder if the code can be entered as a function which will be called if for example enter the formula =CONCATENATEIF(i79) in j79...

**karedog** · 02-13-2017, 12:52 PM

Maybe :

UDF :

Please Login or Register  to view this content.

Formula on J79 :

Formula:

Please Login or Register  to view this content.

**drgkt** · 02-13-2017, 01:40 PM

Perfect! Thank you very much!

**karedog** · 02-13-2017, 01:57 PM

You are welcome, thanks for marking the thread as solved and rep.points.

Regards

**daboho** · 02-14-2017, 07:46 AM

I like it sir karedog

Concatenate cells in 3 columns if value in question is found in another column

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate cells in 3 columns if value in question is found in another column

Re: Concatenate cells in 2 columns if value in question is found in another column

Re: Concatenate cells in 2 columns if value in question is found in another column

Re: Concatenate cells in 2 columns if value in question is found in another column

Re: Concatenate cells in 3 columns if value in question is found in another column

Thread Information

Users Browsing this Thread

Similar Threads

Concatenate multiple columns into a last column

[SOLVED] Compaing two columns, return value from other column if match found

[SOLVED] Sum value in columns if column value found in another list

Sum one column if a word is found in EITHER of multiple other columns

[SOLVED] VLOOKUP to return value found in 1 of 4 columns to a different column in same row

Macro question re: concatenate two columns

Formula question-when a number in a column is found.

Bookmarks

Bookmarks

Posting Permissions