Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Find corresponding value based on two columns

Hi experts

How would you find the value in column c table a... when value in column A Table A has to be Total ABC and column b tables A has to be ABC..Find the result of this.
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous I hope you are looking for something like this...

     

    LOOKUPVALUE(TableA[ColumnC],TableA[ColumnA],"ABC",TableA[ColumnB],"ABC")

3 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous I hope you are looking for something like this...

     

    LOOKUPVALUE(TableA[ColumnC],TableA[ColumnA],"ABC",TableA[ColumnB],"ABC")
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi The lookupvalue does not like the "ABC" part of the formula...

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        sorted thanks