0

I have some ean codes that I need to get from sheet2 to sheet1. The list are randomly so i need a search formula of som kind. It`s way over my head. Is it possible? This one gives me error: #N/A

#N/A=INDEX($Sheet2.$B$2:$B$100;MATCH(A2;$Sheet2.$A$2:$A$100;0))

So i guess i should be about

4
  • Use VLOOKUP or MATCH plus INDEX. Random isn't a problem. – fixer1234 Dec 15 '16 at 10:16
  • I tried this: =INDEX($Sheet2.$B$2:$B$100;MATCH(A2;$Sheet2.$A$2:$A$100;0)) Gives me error #N/A – Stian Størstfeskar Andersen Dec 15 '16 at 11:22
  • 1
    If you're testing this on the literal example in the question, the product names don't match because of an extra space between "Item" and the number in sheet1. – fixer1234 Dec 15 '16 at 15:45
  • Omg, I see that know. I have struggled with this :P – Stian Størstfeskar Andersen Dec 15 '16 at 16:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.