On Thu, 2006-02-02 at 12:05 -0800, Dennis Marks wrote:
> 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.
Have you tried Bruce's method? I expect that is easiest but I was
thinking more on the line of
=VLOOKUP((SEARCH("7";<cell contents>);A1:B10;2;0)
--
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]
