Using Nested IF and vlookup to extract data

Hi

I need help in the following:

I have another summary report which I need to tally my ID, Item and COM date (IN RED) to the ones in Mthly Report.xls. If the referencing data (all three tabs, Jan, Feb and Mar) for the three columns (RED) in Mthly Report.xls matches all the conditions in the ones in Summary.xls, we will pull out CFM_Date and ETA_Date (IN BLUE) and display in the summary report columns. If there is no matching conditions, the columns will be blank.

I am trying to use a nested IF function with vlookup and have tried for some time now. But it still shows me error. Please help me on this.

I am using excel 2002.

Thanks

Tom Screw

hi

I guess can try it in a single workbook if doing it in separate workbooks is tedious. Appreciate it if you can show me how. Thanx!