Capturing data...

[Kookai]

Hi Guys,

I have 2 Sheets (Request & Report).

In Request Sheet i have Column
A1 - NRS Ref(0001) ,
C1 - Received Date ,
J1 - Reply Date ,
N1 - NRS Status (Compelete,Pending,Under Study,Cancelled,Awaiting Response)

Now, in Report Sheet, i want that if a particular ref is complete, the NRS ref,Received Date and Reply Date will be copied automatically in A2, B2 and C3 of Report sheet.

I want this to apply to every NRS Status.

Is it possible.... im really not good in excel and would really appreciate your help guys.... Thank You,

 

[paddydive]

I think a simple Vlookup and if formula can will help you.

 

[Kookai]

Hi Paddydive,

thank u... but could you please assist me how???

 

[paddydive]

ok !

if we consider NRS ref as a lookup criteria.. then
it would be something like...
In Report sheet :

A2 : =IF(Request!D2="Complete",VLOOKUP(Request!$A$2,Request!$A$2:$C$2,1,0),"")
B2 : =IF(Request!D2="Complete",VLOOKUP(Request!$A$2,Request!$A$2:$C$2,2,0),"")
C2 : =IF(Request!D2="Complete",VLOOKUP(Request!$A$2,Request!$A$2:$C$2,3,0),"")

Only problem with vlookup is it will take first matching row only..