Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 'total' in range
I have a block of data (say A1:P40) and in that range, I have named 2
ranges. A1:A40 is named "Name" and P1:P40 is named Total. What I need is to be able to put the corresponding "Total" for Jeremy (one of the "Name" range) when Jeremy's name is put elsewhere in the workbook. If George is put, then George's total will be there. Name in "Name" range will only appear once. Any help? TIA Esra |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 'total' in range
Assume you enter your name in X1 and you want the total returned in
Y1. Put this formula in Y1: =VLOOKUP(X1,A1:P40,15,0) You could make use of an INDEX/MATCH combination or SUMPRODUCT and then your named ranges would be useful. Hope this helps. Pete On Mar 18, 9:09 pm, "excel" wrote: I have a block of data (say A1:P40) and in that range, I have named 2 ranges. A1:A40 is named "Name" and P1:P40 is named Total. What I need is to be able to put the corresponding "Total" for Jeremy (one of the "Name" range) when Jeremy's name is put elsewhere in the workbook. If George is put, then George's total will be there. Name in "Name" range will only appear once. Any help? TIA Esra |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 'total' in range
On Mar 19, 9:17 am, "Pete_UK" wrote:
Assume you enter your name in X1 and you want the total returned in Y1. Put this formula in Y1: =VLOOKUP(X1,A1:P40,15,0) You could make use of an INDEX/MATCH combination or SUMPRODUCT and then your named ranges would be useful. Hope this helps. Pete On Mar 18, 9:09 pm, "excel" wrote: I have a block of data (say A1:P40) and in that range, I have named 2 ranges. A1:A40 is named "Name" and P1:P40 is named Total. What I need is to be able to put the corresponding "Total" for Jeremy (one of the "Name" range) when Jeremy's name is put elsewhere in the workbook. If George is put, then George's total will be there. Name in "Name" range will only appear once. Any help? TIA Esra- Hide quoted text - - Show quoted text - Hi, Thanks for the quick reply Made a few small changes and all works good now. Dont know why i didnt think of VLOOKUP myself. Esra |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding 'total' in range
Thanks for feeding back - glad it worked for you.
Pete On Mar 18, 9:59 pm, "excel" wrote: On Mar 19, 9:17 am, "Pete_UK" wrote: Assume you enter your name in X1 and you want the total returned in Y1. Put this formula in Y1: =VLOOKUP(X1,A1:P40,15,0) You could make use of an INDEX/MATCH combination or SUMPRODUCT and then your named ranges would be useful. Hope this helps. Pete On Mar 18, 9:09 pm, "excel" wrote: I have a block of data (say A1:P40) and in that range, I have named 2 ranges. A1:A40 is named "Name" and P1:P40 is named Total. What I need is to be able to put the corresponding "Total" for Jeremy (one of the "Name" range) when Jeremy's name is put elsewhere in the workbook. If George is put, then George's total will be there. Name in "Name" range will only appear once. Any help? TIA Esra- Hide quoted text - - Show quoted text - Hi, Thanks for the quick reply Made a few small changes and all works good now. Dont know why i didnt think of VLOOKUP myself. Esra- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding a range of dates to total | Excel Discussion (Misc queries) | |||
Finding combinations to match a total | Excel Discussion (Misc queries) | |||
Finding total via entered text | Excel Worksheet Functions | |||
finding name within range | Excel Worksheet Functions | |||
finding if name within range | Excel Worksheet Functions |