Lookup and Textjoin help

ganesang · #1 08-26-2021, 05:27 AM

Hi thanks for the reply

Can we have sum using char(10) as below?

if multiple names with multiple values

column C column D
RB3043 7.5
Pearl15 1
BR715 1

or

if same name with multiple values

RB3043 290.75 (this is comes from three places)

Please advise

p45cal · #2 08-26-2021, 05:51 AM

As I said, not easily. The pivot table gives this information.
What version of Excel are you using?

ganesang · #3 08-26-2021, 06:02 AM

Ms-Office 365

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
Lookup	Tony Singh	Excel	3	03-06-2015 11:03 AM
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM