Matching with Vlookup Separated Comma Values

  • I have been trying to match the values with vlookup and after that summed up.


    My formula is working well but an error is appear in last highlighted cells .


    Any help will be appreciated

    Files

    • Sample.xlsx

      (13.32 kB, downloaded 54 times, last: )
  • Hello,


    Since you are after creating a Sum ... you could test following tiny modification

    Code
    1. =IFERROR(VLOOKUP(IFERROR(LEFT(A2,(FIND(",",A2,1)-1)),0),Sheet1!$A$3:$B$28,2,FALSE),0)+IFERROR(VLOOKUP(IFERROR(MID(A2,SEARCH(",",A2)+1,SEARCH(",",A2,SEARCH(",",A2)+1)-SEARCH(",",A2)-1),0),Sheet1!$A$3:$B$28,2,FALSE),0)+IFERROR(VLOOKUP(TRIM(RIGHT(SUBSTITUTE(A2,",",REPT(" ",LEN(A2))),LEN(A2))),Sheet1!$A$3:$B$28,2,FALSE),0)

    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • You are welcome :)


    Thanks for your Thanks ...AND for the Like :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)