Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i am in search of Formula / Function in EXCEL-2003 | Excel Discussion (Misc queries) | |||
excel search formula | Excel Discussion (Misc queries) | |||
Excel 2002: Can Vlookup formula search for data with two reference | Excel Discussion (Misc queries) | |||
can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |