formula help (excel2003)

Hi all,
What I have in the attached file is two sheets, DB is a plan and OPR is the executed part of the plan. In OPR column L , M & N I wan find from DB the NEXT NAME, STARTDATE AND THE SCHEDULE NAME.
Reqards,
dubdub

Re: formula help (excel2003)

to illustrated it by example,
look up for rigid(WHD-12) ,name(xxxx_436) and planned start date(31-jul-03) in sheet drlg-opr into sheet db, and after you find a match, under the same rigid,look up for the next orderly date and extract the name and the schedulename that crosspond to that next date and output these three data into the l,m,n columns in sheet drlg-opr. applying this, the results should be XXXX_462,4-Sep-03, SCHEDUL1 for rigid whd-12 in sheet drlg-opr in column l,m,n is and for rigid whd-14 it will be YYYY_411,8-Dec-06,SCHEDUL 2.

Re: formula help (excel2003)

You want to match on two columns: A and B vs B and C. To match on both columns at once, I concatenate them, with a vertical bar | in between as a separator. In this particular case, the vertical bar isn't really necessary, but it can be useful if you have pairs such as "DA3" and "1FG" on the one hand, and "DA31" and "FG" on the other hand. Without the separator, both pairs would be concatenated to "DA31FG", causing a false match. With the separator you get "DA3|1FG" and "DA31|FG".