Report

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

Ask a question hirdesh_saxena 3Posts Wednesday March 9, 2016Registration date March 14, 2016 Last seen - Latest answer on Mar 14, 2016 02:06PM
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 
Helpful
+0
moins plus
Hi Hirdesh,

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

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

i really appreciate that.

Best Regards hirdesh
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!