•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Vlookup returns an exclamation mark
"=VLOOKUP(C5,database!A1:database!B24,1)" returns "!", where "C5" is "b", and on the database sheet (named "database"), "A14" is "b" while "B14" is "c". also, using the TYPE for C5, A14, and B14 all return "2". Vlookup also returns ! when I try to use it for anything else in the database.
I can’t find this issue anywhere online. Why is it doing this?
[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
#VLOOKUP
#database
#exclamation mark
#C5
#A14
#B14
#A1
#B24
#TYPE
#Excel
#return
#formula
#lookup
#issue
#data