LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Multiple Variable Formula

I have the following:

A table with the following data:
AR LA MS OK

<12/31/1984 8.00% 8.00% 8.00% 7.00%

12/31/1984 6.00% 6.00% 8.00% 6.00%


I also have the two variables in which I would like to look up on a
calculation worksheet that uses the data from above in an interest
calculation. The varaibles are as follows and can change depending on the
state in which the loan is being calculated:

State: MS

Loan Issue Date: 01/15/1979

What I am looking for is to be able to automatically populate a cell based
on the variable input. I want the cell to autopopulate by looking at the
variables and cross referencing the variables to the table based on the state
and the issue date so that the person doing the calculation only has to fill
in information and nothing else.

Thanks,

C.W.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF with multiple formula/variable Mtavares Excel Worksheet Functions 5 May 30th 08 11:48 PM
Multiple Variable Formula Help Beth Ann Excel Worksheet Functions 3 January 10th 08 01:26 AM
Multiple Variable Formula Ken Excel Discussion (Misc queries) 1 September 10th 07 04:38 AM
Help - Pivot with multiple variable Firman-EID Excel Worksheet Functions 0 June 26th 06 12:57 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"