How to match 5 Different Columns and Display 1 Value

I have 5 reference cell values which I need it to use to map another cell and display that value.
For Eg:- I need to map State-Area-Type of Property-Area of Property while matching all these from a source data I need to give Proposed Rent Value to the Customer.
Anyone can help me on how to do it?

Like this (with appropriate substitutions)?

IFS(
  AND(
    ISNOTBLANK([State]),
    ISNOTBLANK([Area]),
    ISNOTBLANK([Type of Property]),
    ISNOTBLANK([Area of Property]),
  ),
    ANY(
      SELECT(
        Rent Values[Value],
        AND(
          ([State] = [_THISROW].[State]),
          ([Area] = [_THISROW].[Area]),
          ([Type of Property] = [_THISROW].[Type of Property]),
          ([Area of Property] = [_THISROW].[Area of Property])
        )
      )
    )
)

See also:

3 Likes

Thank you Steve for the solution.
it works for me!!!

1 Like