return string of values from multiple cells

**smr7733** · 09-12-2019, 01:06 PM

I've been trying to come up with a formula for the highlight cell shown below. I've been working with index and Hlookup but i can't seem to get it. I need it to lookup a range of cells if they have a value and return the value from another range in a string.

can someone please help me.

list.png

**KOKOSEK** · 09-13-2019, 04:33 AM

	B	C	D	E	F	G	H
3	box id	1	2	3	4	5	6
4
5	qty in box		3		7	1	2
6
7
8	boxes with parts	2,4,5,6

	B	C
8	boxes with parts	=TEXTJOIN(",",1,IF(C3:H3*C5:H5>0,C3:H3,""))

Formula in C8 have to be accept with Ctrl+Shift+Enter not just Enter (as it is array formula).

**smr7733** · 09-13-2019, 09:09 AM

* Add Reputation.

return string of values from multiple cells

LinkBack

Thread Tools

Rate This Thread

Display

return string of values from multiple cells

Re: return string of values from multiple cells

Re: return string of values from multiple cells

Thread Information

Users Browsing this Thread

Similar Threads

Search for a string and return specific value from multiple values in a column

[SOLVED] Return multiple string values

[SOLVED] Search a string from a column, and return multiple values

Help! Formula: Look up multiple text string and return multiple values

Search for txt string in multiple cells, return row number(s)

[SOLVED] INDEX, cells containing text within string, return corresponding values in next column

[SOLVED] string values do not equal cells, then return msg

Bookmarks

Bookmarks

Posting Permissions