Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Fitting high order polynomials
Recent Comments
Tag Archives: exact match
More on Lookups
Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup on a large amount of data without taking all day, but still retaining the ability to return … Continue reading