| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me... with Case Structure
Thanks for feeding back.
Pete LSB M wrote: you're right, vlookup works perfectly. I just happened to recall seeing a spreadsheet years ago with the case function, which looked a but more elegant. Thanks for your help! :) Pete_UK Wrote: You could use a multiple IF statement, but it sounds as if VLOOKUP would do what you want more precisely. Read Excel Help, and if it is still not clear then post back with some more detail of what you want to do. Hope this helps. Pete -- LSB M ------------------------------------------------------------------------ LSB M's Profile: http://www.excelforum.com/member.php...o&userid=36258 View this thread: http://www.excelforum.com/showthread...hreadid=560518 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Threaded Mode
