Conditional Formatting

  • I have list of Expenses in Sheet2

    Sheet1 contains the detailed expenses of each item

    In Sheet3 in column B, When I select the list of expenses ( Already Done )

    Then ( What I Want to Do is )

    Column C should show only the expenses related to items selected in Column B, The list of Expenses is shown in Sheet1


    • Book1.xlsx

      (10.94 kB, downloaded 20 times, last: )
  • Have you tried Power Query? That might work for this.

  • Here is a UDF developed by Jindon that allows you to do Multi lookups

    I have put the code into the attached