Lookup Values 2 Vertical variables

[Ricardo Cruz]

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

[Tom Ogilvy]

=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
>
>