I am trying to set up a spreadsheet where I can compare potential real estate acquisitions. I currently have the properties listed on one sheet and the financial analysis on another. I am trying to set up an if then else function that allows me to input a Property Number and have the corresponding values for price, taxes and association costs auto-populate on the Financial Analysis page.
My initial approach was to use a nested if then else function but my understanding is that I can only nest 7 if then else statements and I am likely to have more properties than that.
Has anyone had any luck with something like this?
Bookmarks