excel search formula
 

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

excel search formula
 

See your other post

"bcags7" wrote:

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

excel search formula
 

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



"Mike H" wrote:

See your other post

"bcags7" wrote:

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

excel search formula
 

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

On Jan 16, 9:17*am, bcags7 wrote:
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



"Mike H" wrote:
See your other post

"bcags7" wrote:

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- Hide quoted text -

- Show quoted text -