look up if Criteria
 

I need to lookup a column if the total of a column excees a number

i.e

A B
Purfleet 5
Thurrock 7
Grays 8
Billiercay 3

if i want to look up 10 i get thurrock
IF i want to look up 21 i get billiercay

thanks

Hello,

Assuming you have headers and that column C is blank, enter this in C2 and
copy down as needed...

=SUM($B$2:B2)

Then use a formula like this ...

=LOOKUP(10,$C$2:$C$10,$A$2:$A$10)

... where C10 and A10 are the end of your data set and 10 is the value to
lookup.

... if I understood you correctly that is.

--
Regards,
Zack Barresse, aka firefytr

"Purfleet" wrote in message
...
I need to lookup a column if the total of a column excees a number

i.e

A B
Purfleet 5
Thurrock 7
Grays 8
Billiercay 3

if i want to look up 10 i get thurrock
IF i want to look up 21 i get billiercay

thanks

Thanks for that, it works if you have an exsact number

i.e like in my example 5,

But if need it to pick up 10 which would be thurrock

Thanks

alan

"Zack Barresse" wrote:

Hello,

Assuming you have headers and that column C is blank, enter this in C2 and
copy down as needed...

=SUM($B$2:B2)

Then use a formula like this ...

=LOOKUP(10,$C$2:$C$10,$A$2:$A$10)

... where C10 and A10 are the end of your data set and 10 is the value to
lookup.

... if I understood you correctly that is.

--
Regards,
Zack Barresse, aka firefytr

"Purfleet" wrote in message
...
I need to lookup a column if the total of a column excees a number

i.e

A B
Purfleet 5
Thurrock 7
Grays 8
Billiercay 3

if i want to look up 10 i get thurrock
IF i want to look up 21 i get billiercay

thanks