Vlookup not updating
The quickest way to add a stipend amount for each job site to the hourly list is to add a VLOOKUP() function using the following syntax: Note that the two ranges (for a regular data range) must be absolute references.
Figure B shows the results after formatting the new column as Currency and adding header text.
SEE: Choosing your Windows 7 exit strategy: Four options (Tech Pro Research) The simple sheet shown in Figure A contains two Table objects.
The one on the left tracks the hours each employee works at specific work sites.
The solution isn't as difficult as it sounds, but it's more complicated than using an IF() statement to add a fixed amount on travel days.
In this article, we'll combine a VLOOKUP() function, a data validation list, and a Pivot Table to create a simple application that tracks stipend awards for employees when working at off-site job locations.
The structure is flexible enough to accommodate employees who work at multiple off-site locations in a single day.
The VLOOKUP() function will return the correct stipend for each location record.
The error in row 4 was easy to troubleshoot and fix.
This is all fine and dandy when your data is sorted nicely, but it can be a disaster with unsorted data, because VLOOKUP might give you a totally incorrect result.
Even worse, the result might look completely normal.
A data validation control will restrict input to specific sites, avoiding typos and invalid sites.
Finally, a Pivot Table will return stipend totals earned for each employee by employee and date.
In this case, Both problems above can be fixed by forcing VLOOKUP to do an exact match.