my FIRST SHEET

Product Code Product Name
prodkods1 lineoone
prodkods2 linetwo
prodkods3 linetrhree
prodkod4 linefour
prodkod5 linefive

mY sECOND SHEET
customer id customer name Product Name MY RESULT
234 SDAFSDFSDF lineoone prodkods1
235 SDFSDF linetwo prodkod5
567 DFGa linetrhree prodkods3
456 SFDGSD linefour #N/A
56745 linefive #N/A
345345345 SDFSDF TILSA prodkod5

=LOOKUP(C2,Sheet1!$B$2:$B$6,Sheet1!$A$2:$A$6)



I have tested these functions and they are are totally useless