Forum Discussion
Solved
LOOKUPVALUE returns blank and unable to recognize dates
I have two tables a. BALANCES: contains balances of certain accounts, denominated in the local currency b. FXRATES: contains conversion rates to convert from USD to whatever the local currency is. ...
Thank you Dale. I have solved the issue.
In the schema, even though the LOOKUPVALUE formula only warrants that both the BALANCES and FXRATES tables are populated, apparently, I will also need to populate a third table (BENCHMARK table) which has a relationship with the Master Date Table. My conclusion is that there may be a completeness requirement for the formulae to work. Do you have an idea why that is? Please see my schema below.
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi blazeken,
The formula in your first post only have two search column parameters. So I don't know how you will add the third table. The formula should work. I have no other idea without data.
Best Regards!
Dale
Thank you for your help Dale. This issue is now solved.