Thread: Returning Multiple Values into One Cell

A B C D E F
1 _ 3 4 _ _


I am trying to figure out a formula that will return: A C D. The logic in plain English is: IF row 2 is greater then 0 (or contains value) provide corresponding value in row 1. I am trying to get the results to all return to one cell with a space between them. I have been looking for a tutorial what would teach me how to build such a formula but have been unable to locate one. Any help is greatly appreciated.

Thanks,
John

John

Assuming that your ABCD etc starts in A1, and the numeric starts in A2 then

A3: =IF(NOT(ISBLANK(A2)),A1,"")
B3: =IF(NOT(ISBLANK(B2)),A3&" "&B1,A3)
Copy from B3 across as required.

Then, using your example,
G3: =TRIM(F3)

See how that goes.

rylo