Simple formula help
 

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?

You just need to sort your list ascending based on the first column.
Then you can use a vlookup as follows:

=vlookup(A1, A4:B10,2)

The A4:B10 is the area where you have your data table shown in your
original post. The vlookup will go to the nearest value that is less
than or equal to it and then pull the second column. Let me know if
you need a hand. Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=381077

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

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" wrote in
message ...

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