| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup error
thank you. I will give that a try.
"Dave Peterson" wrote: Just a guess. If your formula reevalates with a simple F2, followed by an enter, maybe excel needs to be awakened (a very technical term!). I'd select all the cells and do this: edit|replace what: = (just an equal sign) with: = (that same equal sign) replace all Excel will see that each formula is changing (for its purposes--not yours) and recalc. Vlookup not accurate wrote: I basically just retype the formula. Here is what it looks like: =VLOOKUP($C6,'[Names List.xls]Sheet1'!$A:$J,7,FALSE) Thanks again for your help. "Dave Peterson" wrote: What does "re-do the formula" mean? If all you do is hit F2, followed by enter, then I don't have any more guesses. You may want to post the formula you're using. (and false and 0 are equivalent as that 4th argument) Vlookup not accurate wrote: Thank you for your help. I checked my settings and they are set to automatic. Something really strange is going on here. "Dave Peterson" wrote: My first guess is that you don't have calculation set for automatic: tools|Options|calculation tab Vlookup not accurate wrote: I have a spreadsheet that has employees badge numbers in the first column, employee names in the second column and employee department numbers in the third column. I have a vlookup formula in another workbook that links to this spreadsheet, when you type the employee's badge number it is supposed to automatically bring up the employee's name in the cell in the next column. Most of the time it works just fine, but every once in awhile it comes up with the incorrect employee's name. Sometimes it is four or five rows above the correct employee's name (and the badge numbers aren't even close to being the same). The spreadsheet is alphabetized by employee name. I looked online and saw that when using the vlookup function you have to make sure that cells with numbers in them aren't formatted as text. I made sure that all of the cells with numbers are formatted as numbers. But I don't know if this will help or not, since the problem seems to happen randomly. To fix the problem I just re-do the formula and then it seems to work fine, but not everyone using the forms knows how to do this and some of the forms are protected. Hopefully this makes sense. Thank you for your help. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REF# error using VLOOKUP | Excel Worksheet Functions | |||
| vlookup error - recognition of value | Excel Worksheet Functions | |||
| Fill down error for Vlookup | Excel Worksheet Functions | |||
| vlookup weird error | Excel Worksheet Functions | |||
| vlookup error | Excel Discussion (Misc queries) | |||
Hybrid Mode
