Thread: Vlookup and Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Hankin[_4_] Chris Hankin[_4_] is offline
external usenet poster
 
Posts: 56
Default Vlookup and Sum

Hello, could someone please help me with the following?

I need Excel 2003 to Vlookup column G and look up the number: 100206.
Then, I need it to sum all the values in column O and place the final
summed figure in cell: AA3.

I am using Windows XP and Excel 2003.

The title heading for column G (cell: G2) is: Cost Centre Code
(Baseline).

The title heading for column O (cell: O2) is: Actual Expenditure
(inc.GST).

The name of the worksheet is: Register.

Any help with this would be greatly appreciated.

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***