A rather involved "if-then" spreadsheet. Anyone?

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

Hi! Thanks for looking! I was hoping someone could point
me in the right direction for a resource to help with the
following:

I would like to make a spreadsheet (with macros) for a work
project. We are a mortgage broker that uses about 300
different lenders. Problem is, each lender has different
criteria on what property types, credit scores, etc. that
they will lend on. I would like the spreadsheet to involve
"if-then" functions so that the user could click on buttons
and reduce the number of potential lenders. For example,
of 300 lenders, only 50 or so will lend on mobile homes.
The spreadsheet could start with 300 lenders, the user
could click on "Mobile Home YES" and now the pool of
lenders is reduced to 50. Ideally, this would work across
many characteristics such as "Prior bankruptcy", "Michigan
Property", and about 40 others. Any ideas where I might be
able to find a way to accomplish this? Thanks for any help!
 
Just use Data / Filter / Autofilter. With 300 lenders listed in say A2:A301,
and the things they will lend on across say B1:Z1, and a Yes in each field where
a lender will lend on that, select A1:Z301 and do Data / Filter / Autofilter.
You can then just use the dropdown arrows selecting where = "Yes" to home in on
those that meet all criteria.
 
Back
Top