excel search formula

[bcags7]

I'm trying to create a formula that searches a column for the last cell that
contains data, and then returns that value to a cell in another worksheet.
Could anyone help me out with this? Thanks

 

[Mike H]

See your other post

 

[bcags7]

Thanks for the input but these formulas are not working. I'm getting a return
value of #N/A. I've found a another formula in a previous post that seems to
work...=LOOKUP(9.99999999999999E+307,A2:K2).

Just a couple questions though...what is the 9.999999E+307? And is it
possible to search a whole column and not just the range, such as A2:K2. In
my worksheet I'm trying to search column H for the last numerical value.
Thanks again

 

[Pete_UK]

The number 9.99999999999999E+307 is the largest number that Excel can
handle, so the formula finds the last number in the range which is
less than this. You can use a smaller number, eg 10^10, as long as it
is larger than the numbers which you expect to have. Try this:

=LOOKUP(10^10,H:H)

to see if it works for you. If you are looking for text values, then
you can use 255 "Z"s as a suitable "large" text value.

Hope this helps.

Pete