This Post is to support the last Post. It is a review of a simple application of VLookUp.
The VLookUp is reviewed in
_1) Simple single value first argument form
_2) Multiple value first argument form

The example used is the same as that used in the demo of Intercept and Implicit Intersection for single breadth ranges in VLookUp in the last Post

_1) Simples use of VLookUp ( non CSE )
_1a) Single formula, like written in cell B3 this: = VLOOKUP(A3,$A$16:$C$33,3,FALSE)
Consider the final Screenshot below where the first 10 rows are to be used for our VLookUp formulas, and the range A16:C33 is the Look up table used in the VLookUp formula. ( It might help if you copy that to a spare worksheet when following the explanations. Take care to copy to the correct range area. Alternatively the worksheets "XLORX" and "Intercepts" in the uploaded file have a mixture of the various formulas and tables )

Just to refresh what is going on: VLookUp is:
https://support.office.com/en-us/art...8-93a18ad188a1
Simplified VLOOKUP function says,
_ =VLOOKUP( argument1 , argument2 , argument3 , argumant4 )
_ =VLOOKUP( argument1 ,
argument2 ,
argument3 ,
argumant4 )
_ = VLOOKUP(A3 , $A$16:$C$33 , 3 , FALSE)
_ = VLOOKUP(A3 ,
$A$16:$C$33,
3,
FALSE)
_ =VLOOKUP([size=1]Value you want to look up,
range where you want to lookup the value,
the column number in the range containing the return value,
Exact Match or Approximate Match