Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return mulitple values based on the contents of another cel
Should be simple but I have not been able to figure it out. HELP!
A1 can contain a number between 1 and 50 I am wanting to program A2 to show the result of A, B or C depending on the value of A1. For example, if: A1 contains 1 or 4 or 7 or 10, I want the value of A2 to show "A". A1 contains 2 or 5 or 8 or 11, I want the value of A2 to show "B" A1 contains 3 or 6 or 9 or 12, I want the value of Aw to show "C" Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to return mulitple corresponding values | Excel Worksheet Functions | |||
Lookup mulitple values and return one | Excel Worksheet Functions | |||
Return entries from one named range based on the contents of another | Excel Worksheet Functions | |||
return mulitple values Help!!! Excel 2003 | Excel Discussion (Misc queries) | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions |