Requesting for a formula to retun text.

[lifeisaspreadsheet]

I'm requesting some help with a formula quite sure it'll be simple for you all...

Situation:

Column J to R. Each row between these only has a title once (say if K4 has Manger VP all the others i.e J4, L4, M4, N4, O4, P4, Q4, R4 will be blank)

Formula required:

For every row on Column D (D4 onwards). I need to return the title in D4, D5, D6 and likewise.

Condition:

It should ignore the formula that returns the job title in columns J to R

My apologies for not posting an excel file. I understand it would have been all the more easier but due to some tech issues my internet isn't working so am using phone.

Thank you for the help!

[Daedalus24]

Hi
Tell me if I understand the problem right:
You need every cell in column D to return the value in that row, from whichever column it is in, eg h5 and k6

[lifeisaspreadsheet]

What I need is:

If J4 - R4 if K4 has a text it should be returned in D4.
If J5 - R5 if P5 has a text it should be returned in D5 and so on and so forth.

There will be only one column J to R that will have a text for each row.

Please let me know if I'm unclear. Hope I'm not.

Thanks!

[Daedalus24]

Ok, I understand. Now I'll think up a good solution for you

[Daedalus24]

Also, is it ok if extra columns are used?

[lifeisaspreadsheet]

If that can be avoided. My file is already extremely heavy so I don't want to make it more heavy and complex. I'm sure you'll understand what I mean...

Thanks a lot.

[FDibbins]

Your description is very confusing (for me anyway). You say rows, then talk about columns?

Either upload a file - preferable (ands yes, I did read you are on your phone, but if you are on your phone, you cant fix your file anyway) or explain what you have/want a bit clearer

[Daedalus24]

I have a solution in mind, but the formula is a bit long. is that acceptable? No extra columns will be needed

[lifeisaspreadsheet]

As long as it does not make my file more heavy. I'm okay with what ever it is.

[Daedalus24]

Please Login or Register  to view this content.

Try this formula; it's working for me

[lifeisaspreadsheet]

Thanks! But this is something I already have. What I'm looking for is a Find / ISTEXT formula.

Can you help me with it.

Thanks in anycase.

[Daedalus24]

As far as I know, even with ISTEXT, you'll need to account for every column separately. It will still be a rather long formula

[Tony Valko]

If I understand what you want, try this:

=INDEX(J4:R4,MATCH("*",J4:R4,0))

Copy down as needed.

[lifeisaspreadsheet]

Yes, yes...this should do. Thank you!

I'll seek further advise if need be. Cheers!

[Tony Valko]

You're welcome. Thanks for the feedback!