Solve : VLOOKUP question?

1.	Solve : VLOOKUP question?
Answer» Is there a way to use VLOOKUP(or something else) to average the dollar amount in Column B based on the ZIP code in Column A. I know subtotaling would do it but I'm going to have several columns with VARYING data in the ROWS so I need another METHOD for perofrming this. AB 01985 $534.35 01985 $426.66 01950 $384.24 01950 $354.54 01950 $385.55 01950 $391.91 01950 $382.00 01950 $378.92 01952 $392.78 01951 $368.09 01922 $396.77 01969 $415.46 01969 $303.30 01913 $373.19 01913 $400.73 01913 $387.51 You can ADD up Column A in (C,1). Then add up Column B in (D,1). You can then Average the two in (E,1). You then hid Column C & D. That may work for you i dont know give it a try. TELL me if it worked

Discussion