Auto Fill a row from another row

Minni

I am trying to autofill a row with a specific number when a certain drop down in used in another column but I am getting an error. I am not seeing an Automation or a conditional format that supports this so I am assuming that this will require a function but I am not able to figure out which one.

IE- When FY23 is chosen under project name, I want Account Number to auto fill account number 123-456-789 and when FY24 is chosen I want account number to auto fill 987-654-321

Can anyone assist with this one?

Ramzi

Try this -

In your Account Number (CPR) field, use this formula:

=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))

If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.

I hope this helps you. Have a great day!

Ramzi

Ramzi

Try this -

In your Account Number (CPR) field, use this formula:

=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))

If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.

I hope this helps you. Have a great day!

Ramzi

Minni

@Ramzi You are my HERO!!! Thank you so very very much!! It worked!!

Ramzi

Happy to help!

Cheers,

Ramzi

Minni

@Ramzi I had it all set and someone at some point went in and messed it up and now I am having an issue with using multiple IFs in the same cell. Can you assist?