•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
XLookup Returning Values for Alpha and Special Characters but not Numbers
I created a table with numbers, alpha, and special characters. When I run the XLookup function, it only returns the values for the alpha and special characters.
I ran a MID function to separate the characters from a string and then wanted to reference the table against each character to return a value. When I do the XLookup on the table without the MID function, it does work.
What am I missing in the MID function that only the numbers won't work?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#XLookup
#MID function
#alpha characters
#special characters
#numbers
#table
#function
#return values
#reference
#string
#separate characters
#return a value
#Excel
#lookup function