Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get the Starsign given a date in a table
I have a table with the dates for each starsign. Entering a date into a
cell, I want Excel to work out what the starsign is from the table. I used the IF statement, but I cant nest more than 7 IF statements. How would one do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get the Starsign given a date in a table
Look in HELP for the VLOOKUP() function.
Post again in this thread if you have problems using it. -- Kind regards, Niek Otten "Max Mariola" <Max wrote in message ... I have a table with the dates for each starsign. Entering a date into a cell, I want Excel to work out what the starsign is from the table. I used the IF statement, but I cant nest more than 7 IF statements. How would one do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
how do I troubleshoot date formats in a pivot table report? | Excel Discussion (Misc queries) |