I am trying to produce a value in excel by matching another value. Example I am holding my house for 5,6,7 years, I want to match that 5,6,7 year period with the expected home value in another column that has the expected value in thyat year 5,6,7. If A5 (5) = D5 (5) then the value I want is in E5 (=1,250,000)
Solved by M. D. in 20 mins