Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
205
Views
Topic starter
I cannot get my data to return the correct value. It keeps giving me a #N/A. This is my formula. Has anyone else had this issue?
=XLOOKUP(N6,Legends!$A$23:$A$47,Legends!$B$23:$B$47)
Posted : 28/07/2023 12:28 pm
Hi Tina,
There's no file attached with data to test this on so hard to say.
If I use that formula in an empty workbook, that has a sheet called Legends, it returns 0. So syntactically the formula is ok. Must be a data issue.
If I fill in dummy data to the ranges in your formula, I get #N/A if N6 is empty or contains a value that isn't in the range Legends!$A23:$A47
If that hasn't helped fix it, please attach a file with the data this XLOOKUP is using.
Regards
Phil
Posted : 28/07/2023 7:10 pm
