I tried them both but it didn't work...sorry, can you please help me again? I tried Googling for a few hours and I saw the Match function, I tried that too, but I got errors because I don't know if the lookup_value can be a range instead of just one number. I also saw SUMPRODUCT function but I'm completely confused by that one. Any help that I can get from you would be great. Thanks!
Bookmarks