View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark C[_2_] Mark C[_2_] is offline
external usenet poster
 
Posts: 8
Default Pulling data from multiple spreadsheet

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