•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel keeps throwoing me reference errors and refencing the wrong table
Our take
It sounds like you're experiencing frustrating reference errors in Excel, particularly when trying to use VLOOKUP across different tables. It’s common for users to face challenges when altering column arrangements, leading to #REF and #N/A errors. These issues can arise even when the tables have distinct names, as Excel may still reference the wrong data. Let’s explore how to resolve these errors and ensure your formulas work seamlessly, empowering you to manage your data more effectively. Your productivity deserves a hassle-free experience!
Both tables have got completely different names but it's deciding to refernece the wrong table. The first three colunms, VLOOKUP correctly done what I wanted it to do. Now when I changed colunms, I keep getting #REF and #N/A when I drag the colunms
Screenshot of the refernce table
Screenshot of the wrong table
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#google sheets#reference errors#VLOOKUP##REF##N/A#tables#column#drag#different names#referencing#screenshot#correctly done#error messages#referring#data reference#Excel