•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
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]
Want to read more?
Check out the full article on the original site
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