Forum Discussion
Excel jumps to A1 when selecting a range on another sheet during VLOOKUP
Hi everyone, I’m experiencing a strange issue in Excel and I’m hoping someone can help. Steps to reproduce the problem: Open a workbook with at least two sheets (Sheet1 and Sheet2). On Sheet1, s...
Try below as workarounds:
1. Pre-select the range before typing the formula
- Go to Sheet2, select the desired range (e.g., $C$3:$E$100), then return to Sheet1 and type the formula manually using that reference.
2. Use the Name Manager
- Define a named range for the lookup table on Sheet2.
- Then use that name in your formula:
=VLOOKUP(A2, LookupTable, 2, FALSE)3. Type the full reference manually
- Instead of switching sheets mid-formula, type:
=VLOOKUP(A2, Sheet2!$C$3:$E$100, 2, FALSE)4. Update Excel
- Ensure you're running the latest version of Excel.
thank you.
If I use this workaround, it will take a long time for my muscle memory to adjust. I’ve been using Excel for over 6 years, and this workaround isn’t an option for me. Yes, it’s a solution, but Excel wasn’t intended to behave this way.
Thanks again
