Need to find a data in a column and copy below cell data or add [Solved/Closed]

Report
Posts
3
Registration date
Wednesday March 9, 2016
Status
Member
Last seen
March 14, 2016
-
Posts
3
Registration date
Wednesday March 9, 2016
Status
Member
Last seen
March 14, 2016
-
Hello , Please help me to solve this, it will be very grateful

column A column B column c
1......................... .........2
2.............. 23
3
2............... 25
5

want to use a excel function in column B
if find 2 in columnA which is a value in columnC (c1) then copy below cell data and make it 23 or 25 respectively for example in column B

Thankyou

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi Hirdesh,

Try this formula in column B:
=IF(A2=$C$2,A2&A3,"")

Best regards,
Trowa
Posts
3
Registration date
Wednesday March 9, 2016
Status
Member
Last seen
March 14, 2016

Thankyou so much,

i really appreciate that.

Best Regards hirdesh

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!