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

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

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

"Mike H" wrote:

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