| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to Don: display last entry to cell automatically
the formula =lookup(999999,b:b) resulted in #NAME?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
Hi,
It shouldn't do if you copy it exactly as it appears in your post. Mike "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
Are you using an English version of excel? (Maybe the function is named
something else in your language.) If you don't use English, what language do you use? Are you in R1C1 reference style? try: =lookup(999999,C2) mike CBA wrote: the formula =lookup(999999,b:b) resulted in #NAME? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
Hi,
Also, in some language settings "," is replaced by "." -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
I think it's more common for the list separator to be a semicolon (;) then a
dot. Although, there are differences between decimal and thousands separators, too. Shane Devenshire wrote: Hi, Also, in some language settings "," is replaced by "." -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
The list separator wouldn't cause a #NAME? error. You'd get the general
formula error: The formula you typed contains an error. -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... I think it's more common for the list separator to be a semicolon (;) then a dot. Although, there are differences between decimal and thousands separators, too. Shane Devenshire wrote: Hi, Also, in some language settings "," is replaced by "." -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to Don: display last entry to cell automatically
Me???
<vbg "T. Valko" wrote: The list separator wouldn't cause a #NAME? error. You'd get the general formula error: The formula you typed contains an error. -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... I think it's more common for the list separator to be a semicolon (;) then a dot. Although, there are differences between decimal and thousands separators, too. Shane Devenshire wrote: Hi, Also, in some language settings "," is replaced by "." -- If this helps, please click the Yes button Cheers, Shane Devenshire "mike CBA" wrote: the formula =lookup(999999,b:b) resulted in #NAME? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display last entry into a cell automatically | Excel Worksheet Functions | |||
| automatically prefix cell entry with leading zeros | Excel Worksheet Functions | |||
| Automatically prefix cell entry | Excel Worksheet Functions | |||
| automatically add borders to a cell after entry is complete | Excel Discussion (Misc queries) | |||
| How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
![mike CBA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
