Same formula on two different sheets one works the other does not

Susan Hildebrant

I copied a working formula from one sheet to another sheet and changed a column setting. I cannot figure out why the column name in the formula doesn't "active". Any ideas what is wrong?

Paul Newcome

Yep. I missed the extra one after the first range too. Glad you got it sorted. 👍️

Paul Newcome

Did you recreate the cross sheet references on the new sheet yet?

Susan Hildebrant

yes

Paul Newcome

I also notice that you have an extra curly bracket } after the last range and that your first formula uses a 0 for the MATCH and the second formula uses a 1 (exact vs approximate).

Susan Hildebrant

I just saw two extra curly brackets. I removed the and it works now. I need new glasses. 😕

Thanks for reviewing and finding my error.

Paul Newcome

Yep. I missed the extra one after the first range too. Glad you got it sorted. 👍️