Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and sum
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, |