Pulling data from multiple rows and columns
 

How can I use a formula to pull data from a table with labeled columns and
labeled rows that when I select a column label and a row label it would
cross reference both to select the value. For example : a pricing sheet
shows % of loan amounts financed in columns and rows show FICO scores, cross
reference those and you will find the interest rate for a customer with the
given FICO and % loan. How can I use a formula to pull that up given % and
the FICO?

Pulling data from multiple rows and columns
 

One way ..

Assume source table in A1:D4,
B1:D1 = loan percents
A2:A4 = FICO scores

With F1:G1 containing the inputs for Loan% and FICO score
place in say H1:
=INDEX($A$1:$D$4,MATCH(G1,$A$1:$A$4,0),MATCH(F1,$A $1:$D$1,0))
Copy H1 down to return results for other input sets in F2:G2, F3:G3 etc
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark C" wrote:
How can I use a formula to pull data from a table with labeled columns and
labeled rows that when I select a column label and a row label it would
cross reference both to select the value. For example : a pricing sheet
shows % of loan amounts financed in columns and rows show FICO scores, cross
reference those and you will find the interest rate for a customer with the
given FICO and % loan. How can I use a formula to pull that up given % and
the FICO?

Pulling data from multiple rows and columns
 

Awesome, thanks.

"Max" wrote:

One way ..

Assume source table in A1:D4,
B1:D1 = loan percents
A2:A4 = FICO scores

With F1:G1 containing the inputs for Loan% and FICO score
place in say H1:
=INDEX($A$1:$D$4,MATCH(G1,$A$1:$A$4,0),MATCH(F1,$A $1:$D$1,0))
Copy H1 down to return results for other input sets in F2:G2, F3:G3 etc
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark C" wrote:
How can I use a formula to pull data from a table with labeled columns and
labeled rows that when I select a column label and a row label it would
cross reference both to select the value. For example : a pricing sheet
shows % of loan amounts financed in columns and rows show FICO scores, cross
reference those and you will find the interest rate for a customer with the
given FICO and % loan. How can I use a formula to pull that up given % and
the FICO?

Pulling data from multiple rows and columns
 

Pleasure`, Mark.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark C" wrote in message
...
Awesome, thanks.