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
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
Hello,
Since you are after creating a Sum ... you could test following tiny modification
=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
Thank you very much you corrected the mistake.
You are welcome
Thanks for your Thanks ...AND for the Like
Don’t have an account yet? Register yourself now and be a part of our community!