Matching with Vlookup Separated Comma Values

  • 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:)