how to get data from one work sheet to another with specific conditions

[juhee]

Hi,

I am dealing with a large database and need to get data from one worksheet to another. In the attached excel file. I need to get data from CSMAR sheet to FSF sheet.

In the FSF sheet in column "J" & "K" I need the start and end date, respectively from CSMAR sheet column "D" & "E". The data in FSF sheet is required for the stock code mentioned in column "G" (Column "A" in CSMAR sheet), for the year mentioned in column "D" (column "B" in CSMAR sheet) and for the name mentioned in column "I" (Column "C" in CSMAR sheet).

Can anyone pls help me. I need this data urgently.

Regards,
Juhee

[juhee]

Hi,

I have used the following formulas in the FSF sheet:

In Column "J" -=LOOKUP(3,1/((CSMAR!$B$3:$B$56=$L5)*(CSMAR!$A$3:$A$56=$G5)*(CSMAR!$C$3:$C$56=$I5)),CSMAR!$D$3:$D$56)

In column "K" - =LOOKUP(3,1/((CSMAR!$B$3:$B$56=$L5)*(CSMAR!$A$3:$A$56=$G5)*(CSMAR!$C$3:$C$56=$I5)),CSMAR!$E$3:$E$56)

These give me the results but the number of observations is very high. IN FSF sheet there are 36500 rows and the CSMAR sheet there are 801980 rows. Excel doesn't respond due to this. Is there any other way of doing it? Which can be run faster?

Please, can anyone help urgently.

Best regards,
Juhee