if function or match or vlookup (im not sure)

[Kwesi_Quartey]

Hi All 

Im somewhat stuck, I have a large spreadsheet with different tabs because I can't pull a large report my database for now.  I am trying to match the values in my main sheet to 

1. return the same value in the sheet 1 from sheet 2.  

sheet 1 

Code

Output

project

P7987-001
P7987-001
P7987-002

sheet 2

Code	Code2
P7987-001	P7987-001-001
P7987-002	P7987-001-002

so I want to use P7987-001 (sheet 1) and compare it too P7987-001-001 (sheet 2) 

and then return a value. 

[#2]

@Kwesi_Quartey 

Could you please clarify a bit

- we take Code in Sheet1 (e.g.  P7987-001)

- find in Sheet2 Code2 for which first 9 characters are equal to Code (e.g. Code2=P7987-001-001)

- if found take value of Code from Sheet2 and return it into Output cell of Sheet1

Like this or something different?