Get the Starsign given a date in a table

M

Max Mariola

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?
 
N

Niek Otten

Look in HELP for the VLOOKUP() function.
Post again in this thread if you have problems using it.
 
Top