Sandy P said:=VLOOKUP(E39,[EMP.XLS]NAME!$A$2:$C$500,3,FALSE) is the formula
I delete names and information on the master spreadsheet when we have
employees that separates employement and then I add them when hire and
employee. I would like my vlookup to look for the current information
I
entered and use this in the other spreadsheet. It does not recognize
the new
information at all. The tools/options/calculation/ automatic is
checked.
Niek Otten said:Hi Sandy,
I don't think you answered any of my questions. You might try
Tools>Options>Calculation tab and check Automatic.
Otherwise you'll have to provide details, if you need an answer....
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|I have a master spreadsheet that has names, badge#, shift and job
code. I
| then have a completely different spreadsheet that has a vlookup
that will
| bring over the name or some of the other above references. The
problem is
| that if we make any changes to the master spreadsheet the vlookup
does not
| recognize these additions, edits or deletions. It acts like it is
still
| reading the old information? How do I make sure that my vlookups
are reading
| the current information?
|
| "Niek Otten" wrote:
|
| > Hi Sandy,
| >
| > Not too much information
| >
| > What is your formula? What insertions/deletions do you do? What
did you expect to happen? What happened instead? etc
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have master spread sheet in Excel that has several vlookups
from several
| > | different workbooks. I am having problems with my vlookups
updating when
| > | there are changes to the other workbooks. (through additions,
deletions or
| > | edits). I would appreciate any help with this.
| >
| >
| >
Roger Govier said:Hi Sandy
I think your problem may be with deletions and insertions.
If your Name sheet had data in rows 2:500 as per your formula, then you
delete 2 rows, the formula would change to
=VLOOKUP(E39,[EMP.XLS]NAME!$A$2:$C$498,3,FALSE)
Now when you add a new Employee at the end of the list, he will be in
row 499 and will not be found with the formula.
Either amend your formula to
=VLOOKUP(E39,[EMP.XLS]NAME!$A:$C$,3,FALSE)
or create a Dynamic named range for your lookup table.
For more help on this take a look at
http://www.contextures.com/xlNames01.html#Dynamic
--
Regards
Roger Govier
Sandy P said:=VLOOKUP(E39,[EMP.XLS]NAME!$A$2:$C$500,3,FALSE) is the formula
I delete names and information on the master spreadsheet when we have
employees that separates employement and then I add them when hire and
employee. I would like my vlookup to look for the current information
I
entered and use this in the other spreadsheet. It does not recognize
the new
information at all. The tools/options/calculation/ automatic is
checked.
Niek Otten said:Hi Sandy,
I don't think you answered any of my questions. You might try
Tools>Options>Calculation tab and check Automatic.
Otherwise you'll have to provide details, if you need an answer....
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|I have a master spreadsheet that has names, badge#, shift and job
code. I
| then have a completely different spreadsheet that has a vlookup
that will
| bring over the name or some of the other above references. The
problem is
| that if we make any changes to the master spreadsheet the vlookup
does not
| recognize these additions, edits or deletions. It acts like it is
still
| reading the old information? How do I make sure that my vlookups
are reading
| the current information?
|
| "Niek Otten" wrote:
|
| > Hi Sandy,
| >
| > Not too much information
| >
| > What is your formula? What insertions/deletions do you do? What
did you expect to happen? What happened instead? etc
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have master spread sheet in Excel that has several vlookups
from several
| > | different workbooks. I am having problems with my vlookups
updating when
| > | there are changes to the other workbooks. (through additions,
deletions or
| > | edits). I would appreciate any help with this.
| >
| >
| >