If cell has characters return column header

[anu_gv]

Hello All,

I am trying to find the solution for my problem. Basically, I am looking for cell has character (non blank cell) and populate column header of that cell.
I have tried to use this formula: =INDEX($B$1:$G$1,MATCH(TRUE,INDEX(B2:G2<>"",),0)) in H2 Cell.
Where B1:G1 is the header.
B2:G2 has only one cell has filled value (characters), other cells are blank.
I have more than 200 rows, when I tried to drag the fill handle down to remaining rows all the rows has same cell value has H2, even though the formula is matching with respective index's.
Likewise I have the formula in H3, H4,..... etc., as below:
H3=INDEX($B$1:$G$1,MATCH(TRUE,INDEX(B3:G3<>"",),0))
H4=INDEX($B$1:$G$1,MATCH(TRUE,INDEX(B4:G4<>"",),0))
...etc.,
Not sure what is the problem. Is anyone let me what could be the problem

Thx
Anu.

 

[Fluff]

Do those formulae return "" or maybe " " if there is an error?

 

[anu_gv]

Do those formulae return "" or maybe " " if there is an error?

Hi Fluff,

Here is the expression I used on those cells from B2:G2.
=IFERROR(VLOOKUP(A2,SheetRef!A:A,1,FALSE),"")
Where SheetRef has 6 different sheets.

Best Regards
Anu.

 

[Fluff]

In that case that shouldn't be a problem.
As you drag down the formula in your op, it should list the header for first value in each row.

Can you post an example of your data showing the problem, using the XL2BB add-in.

 

[anu_gv]

In that case that shouldn't be a problem.
As you drag down the formula in your op, it should list the header for first value in each row.

Can you post an example of your data showing the problem, using the XL2BB add-in.

Hi Fluff,
I am not getting any error.
I am getting incorrect values populated in H3, H4, H5, etc., such as where the empty cells column header instead of cell header with characters filled.
Further more, I have tried the same formula in my personal computer and formula works as I expected. Except the cell range from B2:G2 do not have any expression mentioned.
I have tried to use other expression, but I don't find any better solution.

Thx
Anu.

 

[Fluff]

When you tried the formula on your personal computer, where you using the same data, as the one that is not working correctly?

 

[anu_gv]

When you tried the formula on your personal computer, where you using the same data, as the one that is not working correctly?

No. Fluff.
I have mimic'd same type of concept and manually created those values.
Best Regards
Vasanth.

 

[Fluff]

In that case the problem lies with the original data. Make sure that none of the formulae are returning a space " " rather than "".
Also on your original data is the sheet set to hide 0 values?

 

[anu_gv]

In that case the problem lies with the original data. Make sure that none of the formulae are returning a space " " rather than "".
Also on your original data is the sheet set to hide 0 values?

You are correct Fluff. Column C has space, that is where the problem started.
I have corrected it. It worked fine.
Thanks a lot for guiding me on this problem.
Best Regards
Anu.

 

[Fluff]

Glad it's sorted & thanks for the feedback