I have
CK4 Min. hours & CL4 Max hours & CM4 is going to = Differece between CK4 &
CL4,
CG5:CG65 =names & CJ5:CJ65 =hours remember hours & names belong together,
Now what i want is to have Names transfered over to CK5:CK65 if greater than
28 from Min to Max & leave cells blank if less
Also in CG5:CG65 for names i have this formula =INDIRECT("B" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE)) & I have a #NA only until names are
entered in other cells
So in CK5:CK65 IF LESS THAN 28 lEAVE IT BLANK

see your MIN/MAX post

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
I have
CK4 Min. hours & CL4 Max hours & CM4 is going to = Differece between CK4 &
CL4,
CG5:CG65 =names & CJ5:CJ65 =hours remember hours & names belong together,
Now what i want is to have Names transfered over to CK5:CK65 if greater
than
28 from Min to Max & leave cells blank if less
Also in CG5:CG65 for names i have this formula =INDIRECT("B" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE)) & I have a #NA only until names are
entered in other cells
So in CK5:CK65 IF LESS THAN 28 lEAVE IT BLANK