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.
--
Dennis Marks
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
