I am using VLookup in a sheet, when I drag it down the list the formula copies correctly and references the correct cells, the problem is it copies the value in the cell being dragged not the result of the formula that was dragged down. When I click on the new cells I see the correct formula underneath the incorrect value. When I click on the cell and retype one number or letter in the formula, but its identical the correct value shows.
Any ideas?
Any ideas?