The other day, I was teaching a class on Vlookups and emphasized the importance of making the table_array absolute prior to copying the formula if they're not using named ranges. 2 members of my class panicked and said they'd never done this, but didn't recall their results being inaccurate. When they demonstrated their workbook to me, the formula was automatically created with absolute referencing, which was why there was no issue. When I demonstrated on my machine, the reference was relative. We tried to referencing other worksheets and had the same results. My question is, is there a setting to make absolute referencing the default or am I missing something else?
Bookmarks