Matching a name against a partial postcode

[benmj16]

Hi, please can somebody help me with a problem I am having?

I am very new to excel formulas and stuggling to work out the following:

I have 2 sheets.

Sheet 1 has partial postcodes in column A e.g "LU1" and a name in column B

Sheet 2 has full postcodes in column A e.g "LU1 3DB" and a company name in column B - I would like to populate column C in sheet 2 with the name that matches the parial postcodes in sheet 1 with the full postcodes in sheet 2.

Any help will be hughely appriciated.

Thanks in advance!

[than_gold]

You could try with Vlookup + matches formula to populate the post codes.
please provide a sample excel file, what you looking for. It will be hugely appreciated to help you in better way.

[benmj16]

I have attached a sample excel file.

Thank you!

I am looking to get the name from sheet 1 (column B) to sheet 2 column C. Sometimes the name could be different also which I think complicates it.

[Fluff13]

Try
=INDEX(Sheet1!A$2:B$41,MATCH(LEFT(A2,FIND(" ",A2)-1),Sheet1!A$2:A$41,0),2)

[benmj16]

Thanks but i cant get that to work. It just says N/A in the cell!

[Fluff13]

Not for me it doesn't.
I changed the names to check that it's pulling in the correct data

[benmj16]

It works on the sample sheet but not on my main worksheet! I have tried to change the values but I cant seem to get it right.

[Fluff13]

Can you supply a sample of your actual data?

[benmj16]

I worked out what I was doing wrong. Thank you so much for the help. I am really grateful. Have a wonderful weekend.

[Fluff13]

Glad you sorted it & thanks for the feedback.

Not sure if you're a Falcons fan or not, but we're playing you tonight.