Have a look in the help index for VLOOKUP and change your table to suit.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AJ" wrote in message
...
Hi. I need to create a formula that needs to reference a table. I can't
figure out which excel function to use or combine. As an example:

Value to check vs table = 5,250. and the table looks like this:

Range Amount
4,999.99 and below 100
5000 to 5,999.99 125
6000 to 6,999.99 150

Result should be the figures under Amount column.

Will appreciate if anyone can help me with this.

Thanks,
AJ