lookup

[odesi]

[TABLE="width: 500"]
<tbody>[TR]
[TD]sl
[/TD]
[TD]List
[/TD]
[TD="align: center"]box
[/TD]
[TD]table
[/TD]
[TD]chair
[/TD]
[TD]paper
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]box
[/TD]
[TD]devit
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]paper
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]roki
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]chair
[/TD]
[TD][/TD]
[TD][/TD]
[TD]sumon
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]table
[/TD]
[TD][/TD]
[TD]devit
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

plz help if i right devit, box column, the box automatic coming to list column, if i write roki paper will go to list column, below sumon, devit also same formula. i want to use formula in box cell. how i solve this problem? Thanks advance.

 

[FormR]

Hi, welcome to the forum!

Something like this maybe:

Excel 2013/2016
	A	B	C	D	E	F
1	sl	List	box	table	chair	paper
2	1	box	devit
3	2	paper				roki
4	3	chair			sumon
5	4	table		devit
Sheet1

Cell Formulas
Range	Formula
B2	=LOOKUP(REPT("z",255),C2:F2,$C$1:$F$1)

 

[odesi]

oh sorry pardon me . i am not enable to edit. right is mistake.it is actually write .

 

[odesi]

tnx for answer but not work and not only box cell . i want this formula list column every cell. plz explan ("z",255),

 

[odesi]

plz help if i right devit, box column, the box automatic coming to list column, if i write roki paper will go to list column, below sumon, devit also same formula. i want to use formula in list column every cell. how i solve this problem? Thanks advance.

 

[odesi]

[TABLE="width: 500"]
<tbody>[TR]
[TD]sl[/TD]
[TD]List[/TD]
[TD="align: center"]box[/TD]
[TD]table[/TD]
[TD]chair[/TD]
[TD]paper[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]box[/TD]
[TD]devit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]paper[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]roki[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]chair[/TD]
[TD][/TD]
[TD][/TD]
[TD]sumon[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]table[/TD]
[TD][/TD]
[TD]devit[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

plz help if i write devit in box column, the box automatic coming to list column, if i write roki paper will go to list column, below sumon, devit also same formula. i want to use formula in list column every cell. how i solve this problem? Thanks advance.

 

[FormR]

Hi, in what does the suggestion in post 2 not work for you?

 

[odesi]

I m using xl2007. not working . i want to use formula list column every cell . not only box below every cell also

 

[FormR]

not working

Hi, this does not give us much to go on to help you debug.

- Does the formula return an error? if so, what is the error?
- Does the formula return the wrong results? If so, what results does it return?
- Something else? If so, what are the details?

- Are the empty cells in B2:F5 really empty or do they contain formula that returns a zero length string, i.e. a ""

not only box below every cell also

You do know that the formula in cell B2 needs to copied down to the other cells right?

 

[odesi]

hi i m try ur formula but not working. plz kindly see my yesterday last post. i think i can not explain it properly .