Hi,

I have 2 sheets.

Sheet 1 has columns A-H where column B has about 300 references, e.g. ABC123XXY, DEF234.

Sheet 2 has columns A-D where column C has about 120 references which are shortened versions of these references, e.g. 123 instead of ABC123XXY or 234 instead of DEF234.

Sheet 1 also contains references that have no bearing on sheet 2.

Sheet 2 has column A containing a specific code for each reference.

I need to get the Sheet 2/Column A code to show against the relevant Sheet 1/column B reference on Sheet 1 however Sheet 2 only has shortened versions of Sheet 1 references so it's a partial match thing I can't figure out.

I've tried various things (VLOOKUP, MATCH etc) but I cannot get it to work. I hope someone can and I hope I've explained this enough.

Thanks for any help here.