Index formula problem Excel 2007

Can anyone help sort out this problem

Import C details deliveries to be made that day - sent in from another department.

Workbook "Monday Run" details the drivers run sheet (602 RS) and his load (602OL). If the site ID appears in Import C then a "C" is put in 602 RS column D, and the site ID in 602 OL B28:B40. A vlookup then puts the details from Import C into the respective column in 602OL (D28 to O40).

The problem occurs when a site has two or more orders for delivery that day - in this case both sites C062 and C070 have two deliveries each.

Is there any way to amend the formula to pick up the second delivery from Import C for these sites??

Any help would be appreciated.

Hi,

It's not clear from your description what the layout looks like and therefore difficult to comment. Upload the workbook and manually add the result you expect to see, noting which are the result cells, and no doubt we can come up with something.