Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 23rd 07, 05:11 PM posted to microsoft.public.excel.misc
lap lap is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2
Default VLookup Not Searching the entire cell for Match

My VLookup does not search the entire cell for a match. The cell contains a
description of items. I.E. if "Battery" is in first position it matches, if
"AAA Battery" it does not find it as a match. Here is the VLookup i'm using:


=IF(ISERR(IF(SEARCH(VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1)))=TRUE,"",IF(SEARCH(VLOOKUP(G 2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC TABLE'!$A$1:$A$94,1)))

What do I need to add to have the lookup search the entire lenght of cell?
--
LAP

  #2   Report Post  
Old February 23rd 07, 05:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 459
Default VLookup Not Searching the entire cell for Match

Nel post
*LAP* ha scritto:

My VLookup does not search the entire cell for a match. The cell
contains a description of items. I.E. if "Battery" is in first
position it matches, if "AAA Battery" it does not find it as a match.
Here is the VLookup i'm using:


=IF(ISERR(IF(SEARCH(VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1)))=TRUE,"",IF(SEARCH(VLOOKUP(G 2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1)))

What do I need to add to have the lookup search the entire lenght of
cell?



VLOOKUP search a value or a text in a cell. For this function "Battery" and
"AAA Battery" are two different values, this is the reason why you don't
succeed.

Maybe You should try in a different way...


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Old February 23rd 07, 05:23 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default VLookup Not Searching the entire cell for Match

Try:

VLOOKUP("*" & G2058 & "*",'DESC TABLE'!$A$1:$A$94,1)

"LAP" wrote:

My VLookup does not search the entire cell for a match. The cell contains a
description of items. I.E. if "Battery" is in first position it matches, if
"AAA Battery" it does not find it as a match. Here is the VLookup i'm using:


=IF(ISERR(IF(SEARCH(VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1)))=TRUE,"",IF(SEARCH(VLOOKUP(G 2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC TABLE'!$A$1:$A$94,1)))

What do I need to add to have the lookup search the entire lenght of cell?
--
LAP

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching, matching then searching another list based on the match A.S. Excel Discussion (Misc queries) 1 December 13th 06 05:08 AM
Searching for partial text match in range [email protected] Excel Worksheet Functions 3 September 12th 06 05:58 AM
Relpace entire address with street name only, searching with wildc bclancy12 Excel Worksheet Functions 3 August 7th 06 09:33 PM
Edit macro to match entire cell contents nis75p06 Excel Discussion (Misc queries) 1 September 3rd 05 04:27 PM
Identifying an item in one col/row and searching an entire spreads Bennie Excel Worksheet Functions 0 August 19th 05 01:49 AM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017