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.

 

[shuklaankur281190]

Odesi, Post #2 is the solution as per your description given in post #1 . If you are facing any problem see the post requirement in post #9 .

Without any proper information/expected result we'll unable to reply you.

 

[FormR]

kindly see my yesterday last post

Please stick to this, your original thread.

i think i can not explain it properly.

The formula that has been suggested does what you are asking for so if it "isn't working" for you then you need to help us to diagnose why by responding to the questions already asked, namely:

- 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 ""

 

[odesi]

yes i want the empty cells in B2:F5 really empty. when i write in c column something the name " box" top of c column will go B2 column just same row. d, f column also same work.

 

[FormR]

You have been offered a suggestion that apparently "does not work" - please, try and take the time to describe exactly in what way it does not work.

So, again...

- 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?

 

[odesi]

The formula return not an error.But the formula return the wrong results .that means results return 0 .
I want The name " box" who is located top of c column will go B2 column just same row. d, f column also same work.

 

[FormR]

the formula return the wrong results .that means results return 0

Hi, that would suggest that the cell in the matching header row is blank.

What is the range of cells that contain your header values? What is the first row's range of cells that contain your text? Can you post the exact formula that you tried?

 

[odesi]

ok i will post the exact formula. i will try describe details . plz kindly try to solve my problem .

 

[FormR]

ok i will post the exact formula. i will try describe details

That would be good