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
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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