I am trying to pull in data into a field based upon the values in other fields. Here's a link to a file that shows this:
Book2.xlsx
For example, I want to pull in their blocking assignment located in 'wristband - assignments'!F:F and place it in 'wristband - B'!B4 based upon the series name in...