Forum Discussion
MrSandMan
Apr 07, 2021Copper Contributor
Configure Autoformat Settings
I am having trouble with the autoformat feature in Excel and I wanted to make sure if this is even a feature. I am using the XLOOKUP function in a formula. This formula first looks at the data in...
HansVogelaar
Apr 07, 2021MVP
To "fix" a cell reference, place $ before the column letter and row number:
=XLOOKUP(G3,$B$3:$B$8,$C$3:$C$8)
The official terminology is that the reference G3 is relative, i.e. changeable, while $B$3:$B$8 and $C$3:$C$8 are absolute, i.e. static.