Then use the editfindoptionsmatch entire cell contents.


Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 16:29:00 -0700, stetka
wrote:

I am only using the regular "find" under the edit options

"Ron Coderre" wrote:

If you're using the VLOOKUP or HLOOKUP functions....they have a 4th argument (parameter).
Setting it to FALSE or 0 (zero) will cause them to only find exact (but not case sensitive) matches.

Example:
=VLOOKUP(A1,C1:D10,2,FALSE)

See Excel Help for more info.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"stetka" wrote in message ...
I need to look up an exact number i.e. sn4-10 but it brings up sn4-100 or
sn4-101 etc. how do i do this?