If you enter this formula;
=IF(AND(I31,I3<21),"",VLOOKUP(your lookup parameters))
into I3, and copy it down, it will display a blank cell if the pay-
field number is between 2 & 20.

Cheers
Tony

On May 9, 10:51 am, klafert wrote:
I have a spreadsheet that has 34 lines pers employee. I have a column called
payfield and payfield amount. I want to copy the formula down. Payfield has
Pay field number 1-37 as listed below, but only 34 lines. The formula will
is in the Column L as shown below. After PAY FIELD NUMBER then it starts
over again. Hope this is clear.

COLUMN I COLUMN L
STARTING ROW 2 STARTING ROW 2

Pay Field-Number Payfield Amount
1 Has a VLOOKUP FORMULA
2 BLANK
3 BLANK
4 BLANK
5 BLANK
6 BLANK
7 BLANK
8 BLANK
9 BLANK
10 BLANK
11 BLANK
12 BLANK
13 BLANK
14 BLANK
15 BLANK
16 BLANK
17 BLANK
18 BLANK
19 BLANK
20 BLANK
22 HAS A VLOOKUP FORMULA
23 HAS A VLOOKUP FORMULA
24 HAS A VLOOKUP FORMULA
25 HAS A VLOOKUP FORMULA
26 HAS A VLOOKUP FORMULA
27 HAS A VLOOKUP FORMULA
28 HAS A VLOOKUP FORMULA
29 HAS A VLOOKUP FORMULA
30 HAS A VLOOKUP FORMULA
31 HAS A VLOOKUP FORMULA
32 HAS A VLOOKUP FORMULA
33 HAS A VLOOKUP FORMULA
36 HAS A VLOOKUP FORMULA
37 HAS A VLOOKUP FORMULA

I am looking for an easy way to copy the formula all the way down without
going to the fields one by one and copy the VLOOKUP FORMULA and of course
leave the lines blank that should be. Need to finish this spreadsheet
tonight. I can e-mail the spreadsheet if that will make it clearer.

Thanks in Advance any help or solution. Need to import Beg Balances by
tomorow morning - early am like 3 am at the latest.