Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to do an EXACT LOOKUP | Excel Worksheet Functions | |||
Lookup and Match with not exact numbers | Excel Worksheet Functions | |||
Match - Exact - Lookup? | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions |