Simple formula help

Z

zero

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?
 
C

cvolkert

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
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple formula help 2
function range 1
function range 2
Formula help 1
lookup ranges to find commision 0
Function Range Lookup 2
Help Creating Excel Formula 4
Function Range Lookup AGAIN! 3

Top