How to update formula in a column that has reference from another sheet and I added new data points

Akaur

I have a reference formula in a column that picks up information from another sheet. I recently added more data to the this other sheet. My reference formula column isn't picking up the new data points.

Reference Sheet:

country Name country Code

United States US

Canada CA

I added Germany and Australia to Country Name column and Country Code

My sheet where I have formula isn't showing AU or DE for when the Country Name column in that file has Australia or Germany. Why would that be?

Akaur

Never mind. I got my answer. I should slow down and edit reference range.

Andrée Starå

Hi @Akaur

I hope you're well and safe!

Glad you got it working!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!