I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going to is the "Equipment Ordering"
I have been trying the below formula, but it doesn't work. Please let me know if you need more information to solve!
=IFERROR(INDEX({Location Tracker - SS Range 1}, MATCH([Studio Code]@row, {Location Tracker - SS Range 2})), "")