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

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