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. >
=VLOOKUP(".*7.*";A1:B10;2;0) should work The . signifies any single character and the * signifies zero or more of the previous character(s), so used together = any number of any character. Search for Regular Expressions in help, it provides a well documented list. Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]