solve using vlookup formula

Calibri 11 AA = Copy Paste Format Painter Clipboard Font Alg D3 4 X A 50 E Mortgage Credit Score Loan Amount Rate 1 Client 2 3 Avery Adams 4 Billy Borrower 5 Dee Denver 6 Jane Jackson 7 Gonzalo Juarez 8 usa Lenkov 9 Jen 10 Lizzie Windsor 11 420 550 380 750 800 775 680 480 $ 400,000 $ 350,000 $ 800,000 $ 1,000,000 $ 650,000 $ 300,000 $ 425,000 $ 250,000 12 13 Lookup Table 14 850+ 15 800-849 16 750-799 17 700-749 18650-699 19 600-649 20 550-599 21 500-549 22 450-499 23 400 449 24 350-399 25 300-349 260-299 27 28 29 30 31 32 33 34 35 36 37 2.50 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% Mortgage rate Ready 11 Type here to search