Home |
Search |
Today's Posts |
#1
|
|||
|
|||
WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK
I have set a VLOOKUP formula to match account numbers. How ever I have to
click double click on the cell before the formula recognises the account number. I have to do this for each cell. I have tried different formats. It is not saving me that much time. |
#2
|
|||
|
|||
It sounds like you have Calculation set to Manual. If you set it to
Automatic, it should work OK. (Go to Tools/Options/Calculation). Rgds, ScottO "Half Manx" <Half wrote in message ... | I have set a VLOOKUP formula to match account numbers. How ever I have to | click double click on the cell before the formula recognises the account | number. I have to do this for each cell. I have tried different formats. It | is not saving me that much time. |
#3
|
|||
|
|||
The calculation is set to automatic and the cell format is 'number'. I have
even tried 'F9' calc now, but that doesn't work either. I'm puzzled? "ScottO" wrote: It sounds like you have Calculation set to Manual. If you set it to Automatic, it should work OK. (Go to Tools/Options/Calculation). Rgds, ScottO "Half Manx" <Half wrote in message ... | I have set a VLOOKUP formula to match account numbers. How ever I have to | click double click on the cell before the formula recognises the account | number. I have to do this for each cell. I have tried different formats. It | is not saving me that much time. |
#4
|
|||
|
|||
Try this:
Select a "bad" formula, then: <Edit <Replace In the "Find What" box, enter = In the "Replace With" box, enter = Then hit <Replace. Does that work? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Half Manx" wrote in message ... The calculation is set to automatic and the cell format is 'number'. I have even tried 'F9' calc now, but that doesn't work either. I'm puzzled? "ScottO" wrote: It sounds like you have Calculation set to Manual. If you set it to Automatic, it should work OK. (Go to Tools/Options/Calculation). Rgds, ScottO "Half Manx" <Half wrote in message ... | I have set a VLOOKUP formula to match account numbers. How ever I have to | click double click on the cell before the formula recognises the account | number. I have to do this for each cell. I have tried different formats. It | is not saving me that much time. |
#5
|
|||
|
|||
What a star, it didn't work on the formula but I did it with a number '1'
(find & replace) and this fixed the error. Thanks very much. "Ragdyer" wrote: Try this: Select a "bad" formula, then: <Edit <Replace In the "Find What" box, enter = In the "Replace With" box, enter = Then hit <Replace. Does that work? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Half Manx" wrote in message ... The calculation is set to automatic and the cell format is 'number'. I have even tried 'F9' calc now, but that doesn't work either. I'm puzzled? "ScottO" wrote: It sounds like you have Calculation set to Manual. If you set it to Automatic, it should work OK. (Go to Tools/Options/Calculation). Rgds, ScottO "Half Manx" <Half wrote in message ... | I have set a VLOOKUP formula to match account numbers. How ever I have to | click double click on the cell before the formula recognises the account | number. I have to do this for each cell. I have tried different formats. It | is not saving me that much time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
Enter TODAY if cell has data | New Users to Excel | |||
copying cell names | Excel Discussion (Misc queries) | |||
Why do I have to enter the cell (F2) for cell to calculate? | Excel Discussion (Misc queries) | |||
Alt Enter in a cell | Excel Discussion (Misc queries) |