• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto data fill based on previous cell value reference.

Please check attached sheet is having two tables. First is the value I am getting with my own formula reference second table shows expected result.
I am looking for a formula reference.
If below entry shows in any cell then only the next cell should have the same data.

260SCX2
130SCX10
112SNX10
WR8-88A
CWR8-88

If anyone could please help on this. Thanks in advance.
 

Attachments

  • ChandooBook4.xlsx
    18.3 KB · Views: 15
Last edited:
premjeetgupta
You should reread Forum Rules
There are few sentences about cross-posting eg below
  • If you do cross-post, please put that in your post.
    In this thread, You is same as premjeetgupta
 
Hello Friends,
Seems I could not explain the problem properly due to that I have not received any help as of now.
I am trying to explain in simple manner in this attached file. Hope to get some response.

If any cell having the matching result only the next cell should also have the same matching result.

Thanks
 

Attachments

  • Book2.xlsx
    10.7 KB · Views: 6
Hello Friends,
Seems I could not explain the problem properly due to that I have not received any help as of now.
I am trying to explain in simple manner in this attached file. Hope to get some response.

If any cell having the matching result only the next cell should also have the same matching result.

Thanks
1] This solution refer to your post #7

In C9, formula copied across right :

=IF((C7=0)*(B7="AAA"),"AAA",C7)

2] This solution refer to your post #1

In "PSS32-Slot" sheet C14, copied across to T14 and all copied down :

=IF(ISNUMBER(MATCH(B4,$V$4:$V$8,0)),B4,C4)

Regards
 
Back
Top