M Muaz Registered User. Local time Today, 03:58 Joined Dec 20, 2013 Messages 50 Oct 13, 2017 #1 hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. Example attached Thank you in advance. Regards Muaz :banghead: Attachments example.xlsx example.xlsx 8.2 KB · Views: 161 Last edited: Oct 13, 2017
hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. Example attached Thank you in advance. Regards Muaz :banghead:
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 18:58 Joined May 7, 2009 Messages 20,229 Oct 13, 2017 #2 Use sumif() function =SumIf($g$2:$g$12,b2,$h$2:$h$12)
M Muaz Registered User. Local time Today, 03:58 Joined Dec 20, 2013 Messages 50 Oct 13, 2017 #3 That's great. Thank you very much. Resolved. Regards Muaz
