NEED FORMULA TO EXTRACT DATA

[Kulin Shah]

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.

 

[CLR]

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

 

[Domenic]

Try...

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

or

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

Hope this helps!

 

[Kevin Vaughn]

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)

 

[Kulin Shah]

Thanks a lot got the solution.

Kulin.