search and return cell value

  • Thread starter Thread starter The Jackson Family
  • Start date Start date
T

The Jackson Family

I hope that someone may be able to help.
I have a worksheet that has 7 fixed columns and a variable number of rows.
The rows can range from 1 to many. Cell A1 is dependent upon the value in
the last row in column G. I can locate this with nested "if" statements or
by creating a new column H that will test to see if the next row contains
values.
Is there any function that I can put in cell A1 that will locate the last
row in column G that contains a value and return the value of this cell?
Many Thanks
 
Thanks Frank,
It worked and will save me a lot of time
regards
Allan Jackson
Melbourne
Australia
 
Back
Top