Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
4 tables: the top two tables are noted as Full, 1 is graded Platinum, the 2nd
Premier+, % runs across the top row and FICO numbers down left column, the next two tables are noted as Stated, 1 is graded Platinum, the 2nd Premier+. By entering 4 criteria Full or stated,grade(Platinum or premier+), % and FICO, can I get the cross referenced Interest rate. ex: Full, Platinum, 680,70%=7. Full 65% 70% 75% 80% Platinum 680 7 7 7 7.1256 Platinum 660 7 7.125 7.125 7.25 Platinum 640 7.125 7.125 7.25 7.375 Platinum 620 7.375 7.5 7.5 7.625 Full 65% 70% 75% 80% Premier+ 680 7.25 7.25 7.25 7.375 Premier+ 660 7.25 7.375 7.375 7.5 Premier+ 640 7.375 7.375 7.5 7.625 Premier+ 620 7.625 7.75 7.75 7.875 Stated 65% 70% 75% 80% Platinum 680 7.75 8 8 8.125 Platinum 660 7.75 8.125 8.125 8.25 Platinum 640 7.875 8.125 8.25 8.375 Platinum 620 8.125 8.5 8.5 8.75 Stated 65% 70% 75% 80% Premier+ 680 8 8.25 8.25 8.375 Premier+ 660 8 8.375 8.375 8.5 Premier+ 640 8.125 8.375 8.5 8.625 Premier+ 620 8.375 8.75 8.75 9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling data from multiple rows and columns | Excel Worksheet Functions | |||
pulling data into a master sheet from multiple worksheets | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Exported data pulling into another spreadsheet | Excel Discussion (Misc queries) | |||
Please Help! - Need Help pulling data from one spreadsheet to anot | Excel Worksheet Functions |