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.

NEED FORMULA TO EXTRACT DATA
 

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.

NEED FORMULA TO EXTRACT DATA
 

Try...

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

or

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

Hope this helps!

In article ,
"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.

NEED FORMULA TO EXTRACT DATA
 

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.

NEED FORMULA TO EXTRACT DATA
 

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.