Excel combining vllookup in excel 2003

Joined
Dec 23, 2011
Messages
3
Reaction score
0
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
 

Attachments

  • Assessment Help version.xls.zip
    24.6 KB · Views: 108
  • Assessment help 11-6 11-8.doc
    115 KB · Views: 134
  • Assessment Help report.doc
    107 KB · Views: 162
Joined
Dec 23, 2011
Messages
3
Reaction score
0
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!!!
 
Joined
Dec 23, 2011
Messages
3
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top