Forum Discussion
Lookup formula not working
I am using a LOOKUP formula but it is parially working. It is bringing up values for some columns and not others. Do you know what the error could be? I have checked and all the fields are matching.
Hi homboy27 ,
It sounds like what you’re running into is one of those situations where the formula looks right but a small detail is stopping it from working consistently. A common cause is when the data types don’t fully line up, for example numbers that are stored as text or dates that are formatted differently, which can make it look like they match when they technically don’t. Another thing worth checking is whether there are any leading or trailing spaces or hidden characters in the data, since those can also block a match even if everything looks identical on screen using functions like TRIM or CLEAN on the values can usually sort that out.
It’s also a good idea to double-check that the formula is set to look for exact matches, and that the range and column reference you’re pointing to really do cover the fields you want. Going through those areas step by step usually helps uncover what’s causing the mismatch
Thank you,Tejaswi.
7 Replies
can you provide more information?
Hi homboy27 ,
Are you using LOOKUP https://learn.microsoft.com/en-us/dax/lookup-function-dax
or LOOKUPVALUE https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
Hi homboy27 ,
It sounds like what you’re running into is one of those situations where the formula looks right but a small detail is stopping it from working consistently. A common cause is when the data types don’t fully line up, for example numbers that are stored as text or dates that are formatted differently, which can make it look like they match when they technically don’t. Another thing worth checking is whether there are any leading or trailing spaces or hidden characters in the data, since those can also block a match even if everything looks identical on screen using functions like TRIM or CLEAN on the values can usually sort that out.
It’s also a good idea to double-check that the formula is set to look for exact matches, and that the range and column reference you’re pointing to really do cover the fields you want. Going through those areas step by step usually helps uncover what’s causing the mismatch
Thank you,Tejaswi.
