| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Substitue for the IF Function
I'm needing to display the correct area code for the corresponding postcode,
row two is the example i'm needing to display. The postcode is already there, it the area code i need the formula for. A B 1 Postcode AreaCode 2 2148 02 The data is 1XXX & 2XXX = 02 3XXX, 7XXX & 8XXX = 03 4XXX & 9XXX = 07 0XXX, 5XXX & 6XXX = 08 The "X" refer to different numbers that may be entered. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help on substitue value, by excel function | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Hex2Dec substitue? | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
