I need to run a formula over a range of cells in another worksheet to check
if the value contained in this range exceeds a certain specified number. If
it does, then I require the serial number to be entered into the new sheet
from where I can use the VLOOKUP function to get the details onto the second
sheet.

e.g.
if value on sheet 1 greater than or equal to 30 then copy serial number onto
sheet 2.


I have used the standard functions but these need to be run for each line on
both sheets. Whai I require of this function is that the formula can run
against a range on the first sheet and when the criteria is met then place
another entry onto sheet 2.


HELP Please

--
Many Thanks
Albert