G
Guest
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?
sn4-101 etc. how do i do this?
R
Ron Coderre
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
10,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)
Setting it to FALSE or 0 (zero) will cause them to only find exact (but not case sensitive) matches.
Example:
=VLOOKUP(A1,C1
10,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)
C
Chip Pearson
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)
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)
G
Guest
I am only using the regular "find" under the edit options
G
Gord Dibben
Then use the edit>find>options>match entire cell contents.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP