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

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

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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 2 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