•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Vlookup returns an exclamation mark
Our take
Are you frustrated by your VLOOKUP function returning an exclamation mark instead of the expected value? This common issue can stem from mismatched data types or lookup errors, even when your inputs seem correct. In your case, with "b" in C5 and A14, the formula should ideally return "c" from B14. Understanding the nuances of data types and how VLOOKUP interacts with them is crucial. Keep reading for insights on how to troubleshoot this issue and optimize your spreadsheet for accurate results.
"=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]
Read on the original site
Open the publisher's page for the full experience