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

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!