Finding 'total' in range

[excel]

I have a block of data (say A140) and in that range, I have named 2
ranges. A1:A40 is named "Name" and P140 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

 

[Pete_UK]

Assume you enter your name in X1 and you want the total returned in
Y1. Put this formula in Y1:

=VLOOKUP(X1,A140,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

 

[excel]

Assume you enter your name in X1 and you want the total returned in
Y1. Put this formula in Y1:

=VLOOKUP(X1,A140,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





- 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

 

[Pete_UK]

Thanks for feeding back - glad it worked for you.

Pete