Jan 27 2021 01:44 AM
So I have the table in the picture below, and I used the VLOOKUP to get the count of the "Spirulina 120" for example but when I'm doing it, it just giving me the first value while I want to calculate all the amount of it.
I was going to do it manually but I have more than 500 rows.
This is the what I did -I know it's wrong BTW-
=VLOOKUP(E2,A2:B19,2,FALSE)
Jan 27 2021 02:17 AM
Jan 27 2021 04:21 AM
Hi @VortexNR ,
You can do this in a couple of ways - Pivot or sumIf/s.. the VLOOKUP can't help you now...
see attachment: