Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Values 2 Vertical variables
Hi! I have an excel sheet like this code Date Nominal rate A 01-10-2005 25% 01-12-2006 30% 02-02-2006 31.75% B 01-10-2005 24% 01-12-2006 27,5% 02-02-2006 29.25% I need to get the nominal rate for a certain code according a a date, p.e., for the code A i want the nominal rate at 01-12-2006 which is 30%. One problem is that this sheet is actualizated through time and new dates and rates can be added to the codes (every code is actualizated at the same time even if the rate doesn´t change). Can someone help me please?! thanks you all:) -- Ricardo Cruz ------------------------------------------------------------------------ Ricardo Cruz's Profile: http://www.excelforum.com/member.php...o&userid=33791 View this thread: http://www.excelforum.com/showthread...hreadid=535604 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Values 2 Vertical variables
=Vlookup(DateValue("01-12-2006),Offset($A$1,Match("A",A:A,0)-1,1,100,2),2,False)
Make 100 larger than the largest number of cells you would need to check to get our date. -- Regards, Tom Ogilvy "Ricardo Cruz" wrote: Hi! I have an excel sheet like this code Date Nominal rate A 01-10-2005 25% 01-12-2006 30% 02-02-2006 31.75% B 01-10-2005 24% 01-12-2006 27,5% 02-02-2006 29.25% I need to get the nominal rate for a certain code according a a date, p.e., for the code A i want the nominal rate at 01-12-2006 which is 30%. One problem is that this sheet is actualizated through time and new dates and rates can be added to the codes (every code is actualizated at the same time even if the rate doesn´t change). Can someone help me please?! thanks you all:) -- Ricardo Cruz ------------------------------------------------------------------------ Ricardo Cruz's Profile: http://www.excelforum.com/member.php...o&userid=33791 View this thread: http://www.excelforum.com/showthread...hreadid=535604 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical lookup of pictures | Excel Worksheet Functions | |||
Conditional Vertical Lookup | Excel Worksheet Functions | |||
Vertical Lookup from a List | Excel Worksheet Functions | |||
Vertical Lookup problem | Excel Worksheet Functions | |||
Vertical lookup help needed | Excel Worksheet Functions |