| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning a value in a table referencing ranges
I have a chart 1 that has a list of ranges and if the number falls with in
the range I want the commision value returned to my new work sheet ex: Chart 1 Col A Col B Col C 500 599 50.00 600 699 55.00 if the calculated total on my seperate worksheet A is between 500 599 I want the 50.00 to pull to worksheet A. -- Tammy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returning NA when referencing cell data to another sheet | Excel Worksheet Functions | |||
| Lookup referencing ranges that are variable | Excel Worksheet Functions | |||
| referencing named ranges in VBA | Excel Discussion (Misc queries) | |||
| COUNTIF using # ranges, and referencing 2 other columns | Excel Worksheet Functions | |||
| Referencing Named Ranges | Excel Worksheet Functions | |||
Threaded Mode
