NEED FORMULA TO EXTRACT DATA

On Sheet1 i have the below Data:

A1 B1 C1
01 - 50 = 10
51 - 100 = 20
101 - 150 = 25
151 - 200 = 30
201 - 250 = 45
251 - 300 = 60
so on...

On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
up "45" from Sheet1.

Is this possible. Please suggest a solution for the same!

Many Thanks,



Kulin Shah.

Assuming your - and = signs do not actually appear on Sheet1, try this
formula in Sheet2 cell D3

=VLOOKUP(C3,SHEET1!A:C,3,TRUE)

Vaya con Dios,
Chuck, CABGx3



"Kulin Shah" wrote:

> On Sheet1 i have the below Data:
>
> A1 B1 C1
> 01 - 50 = 10
> 51 - 100 = 20
> 101 - 150 = 25
> 151 - 200 = 30
> 201 - 250 = 45
> 251 - 300 = 60
> so on...
>
> On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
> up "45" from Sheet1.
>
> Is this possible. Please suggest a solution for the same!
>
> Many Thanks,
>
>
>
> Kulin Shah.

Try...

=LOOKUP(Sheet2!C3,Sheet1!A1:A6,Sheet1!C1:C6)

or

=VLOOKUP(Sheet2!C3,Sheet1!A1:C6,3,TRUE)

Hope this helps!

In article <72391863-340D-4442-B2BF-94D47BB5FFE5@microsoft.com>,
"Kulin Shah" <KulinShah@discussions.microsoft.com> wrote:

> On Sheet1 i have the below Data:
>
> A1 B1 C1
> 01 - 50 = 10
> 51 - 100 = 20
> 101 - 150 = 25
> 151 - 200 = 30
> 201 - 250 = 45
> 251 - 300 = 60
> so on...
>
> On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
> up "45" from Sheet1.
>
> Is this possible. Please suggest a solution for the same!
>
> Many Thanks,
>
>
>
> Kulin Shah.

If you restructure your table like so:
1 50 10
51 100 20
101 150 25
151 200 30
201 250 45
251 300 60

You could use this formula:

=VLOOKUP(C3,Sheet1!$A$10:$D$15,3,TRUE)

--
Kevin Vaughn


"Kulin Shah" wrote:

> On Sheet1 i have the below Data:
>
> A1 B1 C1
> 01 - 50 = 10
> 51 - 100 = 20
> 101 - 150 = 25
> 151 - 200 = 30
> 201 - 250 = 45
> 251 - 300 = 60
> so on...
>
> On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
> up "45" from Sheet1.
>
> Is this possible. Please suggest a solution for the same!
>
> Many Thanks,
>
>
>
> Kulin Shah.

Thanks a lot got the solution.

Kulin.

"Kulin Shah" wrote:

> On Sheet1 i have the below Data:
>
> A1 B1 C1
> 01 - 50 = 10
> 51 - 100 = 20
> 101 - 150 = 25
> 151 - 200 = 30
> 201 - 250 = 45
> 251 - 300 = 60
> so on...
>
> On Sheet2 for eg on Cell C3 i have a total on 222, i would Cell D3 to pick
> up "45" from Sheet1.
>
> Is this possible. Please suggest a solution for the same!
>
> Many Thanks,
>
>
>
> Kulin Shah.