Thanks Pete I am just a little bit confused by your formula sorry.

I tried to make it work but i get no results when you say on Sheet 2 on
column
F use this formula =A2 & B2 & C2 & D2 & E2 ( First problem is that i have
information in column F thats were the Item Number is located, so i inserted
the formula in column G) now do i include F2 on that formula too? (item
Number) the result i get in column G is all the words and number together
including the item number,

Now on Sheet1 when i insert the formula
=VLOOKUP(A2&B2&C2&D2&E2,Sheet2!F:G,2,0) i also need to insert it on K wich
is the next available column, so would that change any information on this
formula? i don't understand how is finding just the item number if its
included with everything else and where it says sheet2!F:G should it be G:H
?? since i added the formula on G ?

Thanks