| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Address Range
I have been trying to work on this for a while. We have certain
addresses that we assign our sales employees to try their sales on, example in column A 110-120 Union Square . In column B we have the name of the sales person associated with the range .For this example Joe would be associated with this range . If I put an address into cell D1 (114 Union Square) Is there a way to have an address that falls into the range 110-120 have Joe Returned in E1? Thank you PJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell address in a range | Excel Discussion (Misc queries) | |||
| cell address rather than range name | Excel Discussion (Misc queries) | |||
| Summing a range using INDIRECT & ADDRESS | Excel Worksheet Functions | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
| Address of named range | Excel Worksheet Functions | |||
Threaded Mode
