Excel Tutorial: Using VLOOKUP and FORECAST to Look Up and Interpolate Values in a Table HD

I use Microsoft Excel a lot to quickly look up or estimate look up values (interpolate) from large datasets. Using the functions VLOOKUP and FORECAST will allow you to lookup values and interpolate them from your dataset. VLOOKUP only returns hard values - those values that are currently listed in the dataset. FORECAST has the ability of returning an interpolated value (in between 2 hard values in your dataset). Enjoy!