Ric wrote:
Trying to look thru Column starting at line 74,63,52,41 and finally
going to 30 to see where data appears first. Even if there is data in
30 and 41, I want to look where the data appears first from bottom of
sheet ..say line 63. Have following fomula but not working:

=IF('Piazzo Ware'!C74<0,C74,IF('Piazzo Ware'!C63<0,C63,IF('Piazzo
Ware'!C52<0,C52,IF('Piazzo Ware'!C41<0,C41,IF('Piazzo Ware'!
C30<0,C30,0)))))

Your formula works for me. Can you describe what incorrect result you
are getting?