See how you can do with VLOOKUP on a mortgage calculator that four different types of loans: Begin Annuit? T End Annuit? T treat interest and other loan only.