Hi,

I'm in need of a macro code for the below scenario

A1 B1 C1 D1 E1

A 2000 B 2007 C 2002 D 2010 E 2005

The cell count A1 - E1 may increase or decrease accordingly, need to
check the count in run time.

I/p is given in cell A2, o/p should return in B2

Macro code should satisfy the foll. conditions:

1. If we give a i/p as say 2003 then the code need to check the value
A1 to E1 and should return the value of year less than 2003 i.e. C
corresponding to 2001

2. if we give a i/p as 2000 then the code should return value equal to
2000 i.e. A

3. If we give a i/p as 1999 then the code should return value as
Z(default)

4. Consider the scenario where year 2000 is not present, then if i/p
is given as 2001 then the code should return value as Z(default)

Please help me on this case, let me know if you need any more
clarifications on the above.