=IF(ISNA(VLOOKUP(B2,Array,5,FALSE)),"",VLOOKUP(B2, Array,5,FALSE))

If this post helps click Yes
---------------
Jacob Skaria


"Michael" wrote:

This may have already been covered but I cannot find it...

What I need is this,

Simple Vlookup, but I need to return a value if it matches a text filter

Each lookup value will return several results, but I only want a return if
it matches..

So, if I were to write it how I think it should work..

=VLOOKUP(B2,Array,5,True if Match(text))