Need to find a data in a column and copy below cell data or add

Solved/Closed
hirdesh_saxena
Posts
3
Registration date
Wednesday March 9, 2016
Status
Member
Last seen
March 14, 2016
- Mar 10, 2016 at 09:18 AM
hirdesh_saxena
Posts
3
Registration date
Wednesday March 9, 2016
Status
Member
Last seen
March 14, 2016
- Mar 14, 2016 at 02:06 PM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Mar 14, 2016 at 01:11 PM
Hi Hirdesh,

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

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

Mar 14, 2016 at 02:06 PM
Thankyou so much,

i really appreciate that.

Best Regards hirdesh
0