Forum Discussion

birdie29's avatar
birdie29
Advocate II
9 years ago
Solved

Lookup the date from another table

Hello   I have a table with Budget transactions called 'Budget' and I would like a column within the table to say 'Yes' if the budget transaction date is after the 'Latest Reporting Date', which is...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi birdie29,

     

    Lookupvalue returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
    LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…) 

     

    Please provid us the details table structure of your tables and some sample data of them, so that we can make furhter analysis.

     

    Regards,

    Charlie Liao

     

     

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi birdie29,

 

Lookupvalue returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…) 

 

Please provid us the details table structure of your tables and some sample data of them, so that we can make furhter analysis.

 

Regards,

Charlie Liao

 

 

  • birdie29's avatar
    birdie29
    Advocate II
    9 years ago

    Hi v-caliao-msft

     

    Thank you for your quick reply! I had a complete memory block, apoliges I should have known this.

     

    Thank you

    Chris