reply on: I need an Excel formula \ stacker news ~devs

pull down to refresh

10 sats \ 3 replies \ @sigit 16 Dec \ parent \ on: I need an Excel formula devs

The formula works for the case you describe - see below (also I fixed the range element, is now $A:$D)

Or are you saying there can be multiple lines for the same combination of ID and Service?

In which case you would like to sum the Data column?

0 sats \ 2 replies \ @DarthCoin OP 16 Dec

In which case you would like to sum the Data column?

No I don't want to sum data. Only want to copy data from each service line into a service column.

ID	Service	Data
1234	AAA	4032		AAA	BBB	CCC	DDD	EEE
1234	BBB	145	1234	vlookup or IF ?	vlookup or IF ?	vlookup or IF ?	vlookup or IF ?	vlookup or IF ?
1234	CCC	136,5	456
1234	DDD	48	658
1234	EEE	56
456
456
658
658

0 sats \ 1 reply \ @sigit 16 Dec

Does this make sense?

LKP	ID	Service	Data
=B2&"\|"&C2	1234	AAA	4032		AAA	BBB	CCC	DDD	EEE
^^ Drag this DOWN	1234	BBB	145	1234	=VLOOKUP($E3&"\|"&F$2,$A:$D,4,0)
	1234	CCC	136,5	456	^^ Drag this down, then drag them all across
	1234	DDD	48	658
	1234	EEE	56
	456
	456
	658
	658

By "Drag" I mean the fact that you can click on the bottom right of the cell and "drag" the formula down. This will update the cell references accordingly and display the corresponding values.

Here is a copy of the spreadsheet: https://paste.nostrdev.com/?d557826675410582#BBFDzTe8txYBzY9xhHNfiNvRNtPVZr4kvVACPCrnNfdN

0 sats \ 0 replies \ @DarthCoin OP 16 Dec

I get formula error. Why did you create column A, just to concatenate column B and C? I don't need exactly that, I need only to search and compare.