•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Xlookup is returning "value not available", but only on some cells
Using XLookup, with 3 criteria ranges. Using the formula:
=XLOOKUP(1, (Criteria1_Range=Value1) * (Criteria2_Range=Value2) * (Criteria3_Range=Value3), Return_Range)
Some of the cells are populating the answer, but others are coming back with a error.
All the cells have matching formats, so its not an issue of conflicting formats.
Any help is appreciated. Screen shot, including formula on a cell getting error is included.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#Xlookup
#value not available
#criteria ranges
#formula
#error
#Criteria1_Range
#Value1
#Criteria2_Range
#Value2
#Criteria3_Range
#Value3
#Return_Range
#populating