Forum Discussion
pob_123
Feb 04, 2020Copper Contributor
Vlookup question.
I haven't done it in 3 weeks, and now that I have to use it again, the cell looks weird, before it looks just as in all the diff video's etc about this, but mine has changed, no matter what I do to t...
mathetes
Feb 04, 2020Gold Contributor
Hard to know for sure, but my best guess is that somehow you inadvertently set your Excel Preferences to use what's called "R1C1 Reference Style"---you'll see that down a ways on the "Settings" menu below.
To reset that, go to Excel...Preferences...General (at least, that 's what it is on my Excel for Mac)