to Don: display last entry to cell automatically

  • Thread starter Thread starter mike CBA
  • Start date Start date
Hi,

It shouldn't do if you copy it exactly as it appears in your post.

Mike
 
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)
 
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.
 
The list separator wouldn't cause a #NAME? error. You'd get the general
formula error: The formula you typed contains an error.
 
Me???

<vbg>

T. Valko said:
The list separator wouldn't cause a #NAME? error. You'd get the general
formula error: The formula you typed contains an error.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Excel Msgbox runing beyond posted cell range. 1
find text from 1 col in 2nd col & return value from 3rd col 3
Formula anomaly 7
COUNTIFS with a date for criteria... 1
concatenate if 2
look up formula 2
Conditional Formatting on Index,Match formula 3

Back
Top