Forum Discussion
Solved
Return "Specific value" from table 1, if not found, return value from table 2
Hello, I have Table A and Table B, and I need to create a visual to show the Project Name when selecting a Project Number. Is it possible to create a calculated formula to return Proj Name if foun...
Hi, I found a solution by apending the two tables, concatenating both Proj Name columns and filtering out the blank and duplicates.
Thank you all for your replies.
ExcelMonke
Impactful Individual
Impactful IndividualWhilst Gabry 's solution may get your answer. Please keep in mind the documented issues with using LOOKUPVALUE;
"However, in certain conditions it could include CallbackDataID requests in storage engine queries, resulting in slower execution, lower performance and missed cache hits. When this happens, alternative approaches should be considered"