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

hirdesh_saxena 3 Posts Wednesday March 9, 2016Registration date March 14, 2016 Last seen - Mar 10, 2016 at 09:18 AM - Latest reply: hirdesh_saxena 3 Posts Wednesday March 9, 2016Registration date March 14, 2016 Last seen
- 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
See more 

2 replies

TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - Mar 14, 2016 at 01:11 PM
0
Helpful
1
Hi Hirdesh,

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

Best regards,
Trowa
hirdesh_saxena 3 Posts Wednesday March 9, 2016Registration date March 14, 2016 Last seen - Mar 14, 2016 at 02:06 PM
Thankyou so much,

i really appreciate that.

Best Regards hirdesh