| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a table as reference in creating formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Cross Reference table/Matrix | Excel Discussion (Misc queries) | |||
| Creating a Pivot Table to reference values | Excel Worksheet Functions | |||
| Creating a table from a formula | Excel Discussion (Misc queries) | |||
| Formula using 2 points of reference to return a value from a table | Excel Worksheet Functions | |||
| pivot table : formula to absolute reference a subtotal | Excel Discussion (Misc queries) | |||
Threaded Mode
