Simple formula help

  • Thread starter Thread starter zero
  • Start date Start date
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?
 
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
 
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
 
Back
Top