I have two separate sheets in my workbook, and I want to return data
onto sheet 1 "DATA" from column 12 on sheet 2 "WEIGHTS" by matching
values in the lefthand columns on both sheets. I am new-ish to Excel and
I have only successfully used a Vlookup once. I know my formula is
correct because it is working on the first row.
But when I go to copy it down, I get #REF! and the formula changes to
I know it has to do with selecting the entire sheet and the formula
wanting to add a row onto 65536, but I have no idea how to fix it. How
do I select a column off the second sheet for the table array?