| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling data into a master sheet from multiple worksheets | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Sort multiple rows by data in certain columns | Excel Discussion (Misc queries) | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
| Pulling data from 2 columns for a total | Excel Worksheet Functions | |||
Threaded Mode
