Excel combining vllookup in excel 2003

[fchilluffo]

Hi,

I've been trying to get these three formulas to work in one cell, L18, and I can't get them to work. They are all enclosed with brackets (CSE), and will work indiviually in their own cell.
* The vlookups come from the first sheet (11-6 11-8).

* The following is on the Report sheet
* Cell L10 calulates a date of birth, based on a birth date entered in C10
* Cells E18 - 21 have the following formula
=IF($L$10="11.8",VLOOKUP($C$18,'11-6 11-8'!$A$5:$T$54,2))
=IF($L$10="11.7",VLOOKUP($C$18,'11-6 11-8'!$A$5:$T$54,2))
=IF($L$10="11.6",VLOOKUP($C$18,'11-6 11-8'!$A$5:$T$54,2))
=IF($L$10="11.5",VLOOKUP($C$18,'11-6 11-8'!$A$5:$T$54,2))

I've included the zipped excel file, and copies of a screen print in word to aid you.

Happy Holidays

 

[fchilluffo]

HI,

I knew this would happen. I kept trying while I was waiting for your reply and tried this:

=IF(OR($L$10={"11.5","11.6","11.7","11.8"}),VLOOKUP(C18,'11-6 11-8'!$A$11:$T$54,2,))

And it WORKED!!!

 

[fchilluffo]

Me again,,,,,

Now I need to nest these:

=IF(OR($K$10={"11.5","11.6","11.7","11.8"}),VLOOKUP($C$17,'11-6 11-8'!$A$5:$T$54,2))
with
=IF(OR($K$10={"11.9","11.10","11.11"}),VLOOKUP($C$17,'11-9 11-11'!$A$5:$T$54,2))

These work by themselves but when I try to join them like this, it only returns the value of the second condtion. I don't know if it matters, the tables are on different worksheets for any of the values 11.5 - 11.8 and 11.9 - 11.11.

=IF(OR($K$10={"11.5","11.6","11.7","11.8"}),VLOOKUP($C$17,'11-9 11-11'!$A$5:$T$54,2),IF(OR($K$10={"11.9","11.10","11.11"}),VLOOKUP($C$17,'11-9 11-11'!$A$5:$T$54,2)))

Thanks