•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Vlookup not updating until filter is cleared
Vlookup not updating until filter is cleared. The filter is being applied to the range with the cell containing the vlookup formula.
The vlookup was returning from a row which was deleted, which should then render a N/A result. However, the N/A would not appear until the filter was cleared. In fact I entered several arbitrary numbers for the vlookup to find, some which were not in the dataset, and it still returned any number.
I can provide more info if needed. Excel version is the current 365.
I know using xlookups probably solves this. However I'm just more curious about what's going on under the hood to lead to the unexpected behavior of the vlookup.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#large dataset processing
#row zero
#financial modeling with spreadsheets
#formula generator
#Vlookup
#Excel
#filter
#xlookups
#N/A result
#dataset
#vlookup formula
#arbitrary numbers
#lookup function