looup help

[Miree]

I have the following formula

=IF(F4="","",LOOKUP(F4,Instructions!$L:$L,Instructions!$M:$M))

But it returns the M column value matched to the closed L column value how
can i get it to return exact values only

 

[Mike H]

Hi,

You could do this

=IF(F4="","",VLOOKUP(F4,Instructions!L:M,2,FALSE))

It will now only return an exact match but if it doesn't dind one it returns
#N/A.

If that's a problem then post back.

Mike

 

[Miree]

this worked great is there a way to get it to return a message rather than N/A?