Search only looks at a single field. I am searching multiple records. VLOOKUP will search for text in multiple records. My only problem is that I am doing a wild card search. Find a record if the data is found within a field in the record.
Sheet A Column A Column B 1, 2, 3, 4, AAAA 6, 7, 8, 9, BBBBB 10, 13, 15, CCCCC Sheet B Column A Column B 6 Search and return BBBBB 13 Search and return CCCCC What formula should I put in Sheet B, Column B? "G. Roderick Singleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Thu, 2006-02-02 at 11:00 -0800, Dennis Marks wrote: >> I'm trying to use a regular expression in VLOOKUP and I can't get it to >> work. Maybe I am just using it wrong. >> Assume the following is in a single cell 1, 3, 5, 7, 12, 15, >> There is a blank before the first 1. >> There are many sets of numbers like this in a column. >> I want to do a VLOOKUP to find the record with " 7,".? >> The record indicated above should be found. >> I keep getting n/a. What am I doing wrong? >> >> The numbers are in column A. Returned item in column B >> Formula >> =VLOOKUP(" *7,*";A1:B10;2;0) >> I have tried without the blank before the *. I have tried not using the >> *'s. > > I am no Calc expert but I think you are using VLOOKUP incorrectly. I > would try using the SEARCH function to search the string in the cell for > the value you need. > > Good luck. > -- > PLEASE KEEP MESSAGES ON THE LIST. > OpenOffice.org Documentation Co-Lead > http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
