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:
Thank you Steve for the solution.
it works for me!!!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |