title: vlookup if range satisfies condition
body: <p>here is what I want to do
  I have two tables... the first column is the same in both tables and contains id.
  the 2nd column in the 2nd table is the precision of the id (ex: -1, +3). the 2nd column in the first table is with the tolerances (ex -1+2, -5-2) ...so I want to search for all the values in 1st table that have the same ID as the selected row in the 2nd table and then if the precision is in the tolerance to get the value from the 3rd column in table 1.... in other word I want some sort of vlookup that vlookups only if the value of the precision is in the range.</p>