Hello!
I'm struggling to get the VLOOKUP function to return a value when the array is made up for formulas. Any guidance would be welcomed!
These are my tables. The second table is simply the header row + the margin from table 1.
This where I would like the values returned to by entering a RATING. It is on a separate tab from the data tables. The row for MARGIN works great. The row for RATE does not. The only difference is the use of formulas in table 2.
Here are my two formulas.
MARGIN =XLOOKUP(C11,'Real Estate'!B8:B24,'Real Estate'!C8:F24,,1,-1)
RATE =XLOOKUP(C11,'Real Estate'!H8:H24,'Real Estate'!I8:L24,,1,-1)
I'm struggling to get the VLOOKUP function to return a value when the array is made up for formulas. Any guidance would be welcomed!
These are my tables. The second table is simply the header row + the margin from table 1.
This where I would like the values returned to by entering a RATING. It is on a separate tab from the data tables. The row for MARGIN works great. The row for RATE does not. The only difference is the use of formulas in table 2.
Here are my two formulas.
MARGIN =XLOOKUP(C11,'Real Estate'!B8:B24,'Real Estate'!C8:F24,,1,-1)
RATE =XLOOKUP(C11,'Real Estate'!H8:H24,'Real Estate'!I8:L24,,1,-1)