Lookup of Revenue Tiers

[Cowboys9]

Jumping into the forums on day one and looking for help. I am looking to setup a formula in excel for measuring a Monthly Revenue Share based on total users in a given month. Column A and Column B would contain the below table, where revenue would be based on which table the total users in a given month slotted in. I'm drawing a blank on this one to try and get this to work. Assuming that the "Users in Month" would be in Cell A1, and my actual users in the month go in Cell E1, what formula do I need in Cell E2 to pull the correct value from Column B?

Users in Month	Revenue
0-4,999,999	1000
5,000,000-5,999,999	2000
6,000,000-6,999,999	3000
7,000,000-7,999,999	4000
8,000,000-8,999,999	5000

Any and all help is much appreciated.

[MarvinP]

Hi Cowboys9 and welcome to the forum,

This is a very normal VLookup function with a TRUE as the last argument.
Look at http://www.excelfunctions.net/ExcelVlookup.html for an example (look at the second example where True is used)

If this doesn't help.. Bump this thread and / or attach a sample workbook so we can help more.

[Cowboys9]

Thanks and got it - link was all I needed!