Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum column of vlookup
Hi all,
Here I am again trying to do things that I don't know how to do. Here's the formula in O37 - =VLOOKUP(O18,DE18:DG36,3) Of course this is for row 18 in column O and there are 36 rows. O37 should sum all the rows, not just row 18. It's probably some form of =sum and an array, ahh. Thanks, Michele |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
Vlookup to change a column | Excel Worksheet Functions | |||
VLookup & Column Sum | Excel Worksheet Functions | |||
Vlookup a column then a row | Excel Worksheet Functions | |||
Vlookup through entire column | Excel Worksheet Functions |