Forum Discussion
XLOOKUP error
HI, I am finding that my XLOOKUP is not pulling the value I can see it should be pulling into my Data tab on my spreadsheet. I cannot see where I am going wrong! Can anyone help please? The formula I...
How are you sure it shall return some not zero number? If in any cell
=A298=Allocation!<correct cell>
does it return TRUE of FALSE?
Because I can see the values on the other tab that it should be returning. So for one the values it should be returning 100. Unless I am doing this completely wrong?
Values could look identical but being different, e.g. "abc" and "abc ". Or something with non-printable characters, especially if you copy/pasted something from the web.