Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Section Properties with MeshPY, including torsion and warping
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Finding Prime Numbers with Excel, and using Array Formulas
Recent Comments
Tag Archives: Exact lookup
Time to Lookup
At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Exact lookup, Excel, fast lookup, precise timer, UDF, VBA, VLookup
5 Comments