Enter this formula =Lookup_concat(G3,$D$3:$D$12,$E$3:$E$12) in cell I3 and drag it to the bottom. Now you can use this UDF just like regular worksheet formula. Result = result & " " & Return_val_col.Cells(i, 1).Value If Search_in_col.Cells(i, 1) = Search_string Then Search_in_col As Range, Return_val_col As Range) Function Lookup_concat(Search_string As String, _ To use this approach, please enter this code in your regular module(module1). I would suggest using UDF formula which is simple to implement and use in worksheets. There is no simple solution without using UDF or helper columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |