Index match with a wildcard

[moody]

HI ,
I have a list of IDs number like S0001234AA to S0001234AZ from top to bottom in Column A .Actually the list consist of many Raw data From S0001234 and other IDs with additional alphabaet behind Such As S0001234AA-AZ , S0005678AA-AZ etc..

Now what I would like to do is using a vlookup function to find each S0001234AA-AZ from S0001234.

I could't use trim and just VLookup as it would only give the the first result it find.

Can anyone help?

 

[Asheesh]

Hi Moody...

Attach a sample file please....

 

[azumi]

Just try to upload your sample workbook, and explain the expected results