Excel 2007 : Vlookup data with wildcard "*"

[christeen00]

Hi,

I have problem to insert formula to vlookup data in sheet "TABLE1" from a column which consists of alphabets and wildcard in sheet "TABLE2".
Please refer to my attachment for details.
My results are tabulated in sheet "OUTPUT".
Thanks in advanced.

[NBVC]

First convert the numbers in Table2 to actual numbers, by selecting column C and go to Data|Text to Columns and then click Finish.

Repeat for column D.

Then in Table1, C2 apply formula:

Please Login or Register  to view this content.

copied down