Matching with Vlookup Separated Comma Values

mythu · Mar 18th 2021

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

**Carim** · Mar 18th 2021

Hello,

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

Code

=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

mythu · Mar 19th 2021

Thank you very much you corrected the mistake.

**Carim** · Mar 19th 2021

You are welcome

Thanks for your Thanks ...AND for the Like

Matching with Vlookup Separated Comma Values

Participate now!

Share

Tags