Vlookup or Index and Match Help

[Fayyaz Malik]

I have two excel sheets.
One contains columns, Police Station, District, Phone Number and it is never changed.
The other contains Police Station, District, Phone Number, FIR Date etc.
I want in some way that the sheet two automatically extracts phone numbers from sheet one for specific Police Station and District whenever I enter the data.
Hope You understand my question.

 

[NARAYANK991]

Hi Fayyaz ,

Something like this ?

Narayan

 

[Khalid NGO]

Hi Fayyaz,
Welcome to the forum Chandoo.org...

Can you check this in L2, sheet 02-01-15:
=IFERROR(INDEX(Sheet1!$A$2:$D$956,MATCH('02-01-15'!C2,Sheet1!$B$2:$B$956,0),4),"Not Available")

Copy down.

Regards,


Edit:
Narayan Sir's approach is best

 

[Fayyaz Malik]

You People Rock !
Thanks Narayan and Khalid
Thats Superb

 

[Khalid NGO]

You are welcome...
Thanks for the feedback Fayyaz.

 

[Fayyaz Malik]

In the same Data. I want to Join fir no. and fir date. when I use & function. it changes the date to a number. I want the Date as it is written not be changed to any other format when I join cells. and when extract data from excel to MS Word using Mail Merge function in word having this excel file as my MAILING LIST.

 

[Khalid NGO]

Hi Fayyaz,

I think you should try:
=TEXT(H2,"dd-mm-yyyy")
Where H2 can be your date.

How you are joining Date?
Can you post the formula here?

Regards,

 

[Fayyaz Malik]

Thanks Khalid this worked well.
I was using e.g.

=F2&" ("&G2&")"

 

[Khalid NGO]

Thanks Khalid this worked well.
I was using e.g.

=F2&" ("&G2&")"

Glad it worked.

Thanks for the feedback and welcome back.