Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display diff text based numbers in another cell
I am trying to display a different text string for certain number ranges
based on a number displayed in a different cell. Cell (C25) displays a number in the range of 0-150. I need cell (A26) to display a given text string when the number in (C25) is within a certain range. Range that # in C25 falls within Text to Display 0-9 "Use Good CRM/ADM" 10-15 "Notify Dispatch/Manager" 16-20 "Manager Approval REQ" 20 "CANCEL MISSION" I am new to VBA (learn as I go) so simple soulutions with lots of detailed instructions won't hurt my feelings. -- skyknight |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display diff text based numbers in another cell
You don't need VBA. The VLOOKUP worksheet function will do the
job. In cells G1:H4 (or whatever range you want) enter 0 User Good CRM/ADM 10 Notify Dispatch Manager 15 Manager Approval REQ 20 Cancel Mission Then, use the following formula: =VLOOKUP(C25,G1:H4,2,TRUE) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sky" wrote in message ... I am trying to display a different text string for certain number ranges based on a number displayed in a different cell. Cell (C25) displays a number in the range of 0-150. I need cell (A26) to display a given text string when the number in (C25) is within a certain range. Range that # in C25 falls within Text to Display 0-9 "Use Good CRM/ADM" 10-15 "Notify Dispatch/Manager" 16-20 "Manager Approval REQ" 20 "CANCEL MISSION" I am new to VBA (learn as I go) so simple soulutions with lots of detailed instructions won't hurt my feelings. -- skyknight |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
How do I transform numbers (different ranges) to text (diff. range | Excel Worksheet Functions | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
How can I remove diff. numbers from a cell combined with text | Excel Discussion (Misc queries) |