Lookup Data containing merged cells

[Scottie31]

I need to lookup a value on a spreadsheet that contains merged cells. I have the following information:

Row number 2 contains the date which is in a merged cell over 2 columns.
The other data is on rows 47 & 48 which does not contain any merged cells.

I have a table that needs to populate the "Base" numbers depending on the date and shift (Day/Night)
C D E F G H
02 Date 05/20/10 05/21/10 05/22/10
47 Day/Night 20D 20N 21D 21N 22D 22N
48 Base 40 45 48 50 55 60

Any help would be appreciated.

 

[Brianwarnock]

When you say look up the data do you mean parse the merged data to get the day numbers?

Why would anybody design the spreadsheet to make their work harder?

Brian

 

[MI man]

This may sound ridiculous, but I still want to say that instead of merging the cell, duplicate the value of that cell. for example, you have the 2 columns merged on row2, type in the same data in both the columns instead of merging it.

I don't really know if it works out or not because I haven't tested it right now due to the lack of MS Excel in the present computer that am in now. Do try out. If it's worth, then it's well and good.