title: How to search from a value using VLookUp Excel function from lookup_value starting at end?
body: <p><a href="https://i.stack.imgur.com/xeI8e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xeI8e.png" alt="I have below Data"></a></p>
  
  <p>I used below Vlookup formula to pick my desired data</p>
  
  <pre><code>=VLOOKUP(100,PersonDetails,2,FALSE)
  </code></pre>
  
  <p>Ideally i need the formula to fetch <strong>Adress1 value (abc)</strong> for the <strong>key 100(lookup_value)</strong> from the <strong>named range(PersonDetails)</strong> but the formula doesn't seems to get correct data (<strong>#N/A</strong> is displayed as result). Any workaround for this?</p>
  
  <p>Note : PersonDetails is a named range and not a table.</p>