Hi there,
Is there a way to sum data with a vlookup, as follows:
Style Jan Feb Mar Apr ...
002 100 100 100 100 ...
003 150 150 150 150 ...

In another sheet, I want to sum year-to-date info by style.
sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0)

Thank you and regards,