looup help
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" wrote:
I have the following formula
=IF(F4="","",LOOKUP(F4,Instructions!$L:$L,Instruct ions!$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
|