Copy Data from a Cell to another based 2 conditions

Teffi

New Member
Joined
Aug 3, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello!

I can't seem to figure out how to accomplish the below 2 functions, is it even possible:

1.) If there is an "X" in D and a value in O, then copy value from O to R
2.) If there is a Value in R then auto-populate a "X" in AC; AC currently has a formula of
1691089689144.png
which populates AD and I still need that to happen if AC criteria is met.

Thank you in advance for any guidance.

1691089343332.png
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
I am not sure I understand. If the formula listed as 2.) is in cell AC2, it will be a circular reference. From your screenshot, you have "Fair Market Value" in AD2, is it possible that the formula listed is in cell AD2? Try:

R2 =if(and(D2="x",O2="*"),O2,"")
AC2 =if(R2="*","x","") If the formula in AD2 is =if(isblank(AC2,"","Fair market value") it should still function.
 
Upvote 0
Sorry for my mistype:
R2 = =IF(AND(D2="x",O2<>""),O2," ")
AC2 =IF(R2<>"","x","") If the formula in AD2 (from 2.) is =if(isblank(AC2,"","Fair market value") it should still function.
 
Upvote 0
Sorry for my mistype:
R2 = =IF(AND(D2="x",O2<>""),O2," ")
AC2 =IF(R2<>"","x","") If the formula in AD2 (from 2.) is =if(isblank(AC2,"","Fair market value") it should still function.
OMG!! Thank you that worked perfect!!!! And yes you were correct I did misspeak the Fair Market Value formula was in AD
 
Upvote 1
OMG!! Thank you that worked perfect!!!! And yes you were correct I did misspeak the Fair Market Value formula was in AD
You are welcome. I'm glad this helped. Please mark the reply as resolved for the forum so this post will be marked as resolved 🙂. I hope you have a great day.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top