Simple formula help

I dunno how we got here, but

=Sheet1!A1
put in any cell in Sheet2 will return the value in Sheet1 cell A1

Vaya con Dios,
Chuck, CABGx3



"sam_360" <sam_360.1r0huk_1119416744.0651@excelforum-nospam.com> wrote in
message news:sam_360.1r0huk_1119416744.0651@excelforum-nospam.com...
>
> How do I get a cell in sheet 4 to = a cell in sheet 2?
>
>
> --
> sam_360
> ------------------------------------------------------------------------
> sam_360's Profile:
http://www.excelforum.com/member.php...o&userid=24516
> View this thread: http://www.excelforum.com/showthread...hreadid=381077
>

Hi

I need a simple fórmula that takes a value from a cell (A1 would be fine)
and put a value to other Cell (A2 it's ok) considering what this number is,
and then assigning a value from this table:

msgs value
10000 10
5000 10
4000 9
3000 9
2500 9
2000 8
1500 7
1200 6
1000 5
800 5
600 4
400 3
300 3
200 2
100 1
50 1
0 0


IE: if the A1 cell value is 5500 messages, A2 should be 10
If A1 cell value is 3500 messages, A2 should be 9 and so on.

How can I do that?

I dunno how we got here, but

=Sheet1!A1
put in any cell in Sheet2 will return the value in Sheet1 cell A1

Vaya con Dios,
Chuck, CABGx3



"sam_360" <sam_360.1r0huk_1119416744.0651@excelforum-nospam.com> wrote in
message news:sam_360.1r0huk_1119416744.0651@excelforum-nospam.com...
>
> How do I get a cell in sheet 4 to = a cell in sheet 2?
>
>
> --
> sam_360
> ------------------------------------------------------------------------
> sam_360's Profile:
http://www.excelforum.com/member.php...o&userid=24516
> View this thread: http://www.excelforum.com/showthread...hreadid=381077
>