Forum Discussion
Lookupvalue Returning an Error
Hi Cellblime ,
It sounds like you’re on the right track with using LOOKUPVALUE, but the error you’re encountering typically means that there are multiple matching values in the Letter Descriptions table for a given Letter Code. Double-check that the Letter Code column in the Letter Descriptions table truly has unique values.Use FIRSTNONBLANK BUT NOTE: This will only return the first non blank value found, ignoring all other's.
Letter Description = CALCULATE( FIRSTNONBLANK('Letter Descriptions'[Description], 1), FILTER('Letter Descriptions', 'Letter Descriptions'[Letter Code] = Letters[Letter Code]) )
I hope this help you, if so, please accept as solution and give a Kudo.Thank you.
Please supply some sample data.
You describe the Letters table as only having 1 column? But is that really the case? What is the point of that table?
In this case what is a Letter? Something like A, B etc or a written correspondence?
From what you are trying to do it sounds like you will end up with the same table in both cases? Both containing Letter Description and Letter Code?
Regards
Phil
The Letters table has a few additional fields, I was just trying to avoid complicating the question. The Letters table data is queried and there is no description of the letter code on the database so I created a separate Excel sheet with the description and corresponding letter code, and imported it so I could add the missing description to the Letters table. The Letters table has the following fields, Letter Date, Letter Code, Delivery Method and Customer Number. The Letter Code is a 4 character value with one letter and three numbers, like A123.