I am trying to post a value from a different sheet using Vlookup and a dropdown list.
The dropdown cell is A15. The sheet pulling the data from is cstmr. The column is 11.
The formula works up to and including column 10. From 10 on it produces ERR:502. I’ve checked cell format till blue in the face.
As a test I also eliminated columns before column 10 to confirm if the column which was 11 would work if it became 10. The result, it did not work. It tells me it is something column related.
Why would it work up to a certain column and not in any column after?