Do you want to compare the looked up value with a text string and if
it doesn't match give something else? It is not clear what you mean
by "each lookup vlaue will return several results". Unless you are
using an array function, you are going to get a single result. You
can compare that with something and use the IF function to handle the
logic.

It seems like you just may have this inside out; maybe something more
like

=IF(VLOOKUP(B2, array, 5, false)="text","text","no match"))

Maybe a more detailed example will help.

Ken



On Jun 2, 12:38*pm, 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))