Need macro code to pick data according to year selected

[maniarasan]

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.

 

[Don Guillett Excel MVP]

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.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."