Lookup exact number
 

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?

Lookup exact number
 

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?

Lookup exact number
 

What formula are you using? If you are using VLOOKUP or HLOOKUP, you need to
include the 4th parameter with a value of FALSE.

=VLOOKUP(value,range,offset,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"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?

Lookup exact number
 

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?

Lookup exact number
 

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?