title: How to Vlookup a filtered list
body: <p>I am trying to figure out how to lookup information in a filtered table, returning only visible values.</p>
  
  <p>For example, the data I want to use for the lookup is in cell A3, the lookup data is in another sheet in cells <code>A2:E264</code>. A normal lookup function would be <code>=VLOOKUP(A3,'[IBD.xlsx]IBD'!$A$2:$E$264,2,FALSE)</code>. But if I then autofilter the data in <code>A2:E264</code> such that some rows are hidden, I only want the vlookup function to return a value if the data from A3 is also in a VISIBLE cell in <code>A2:E264</code>, otherwise it should return an error.</p>