Okay, well I decided to just simplify it and created a concatenation of each option into a single cell and used a vlookup on that value. This is working out fine EXCEPT for one condition.

For some reason, when I select the "50,000 ~ 500,000 Sq. Ft. (Per Sq. Ft.)" option, the vlookup returns #N/A. I cannot for the life of me figure out why?? The language is the same, it even happens when I copy the exact contents of the index cell value. The only difference with this option is that the value in the "Price" column are below 1. So I tried the vlookup with "TRUE" condition and it returns a value, but most of the time the incorrect one.

Any thoughts?