• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup or Index and Match Help

Fayyaz Malik

Fayyaz Malik

New Member
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.
 

Attachments

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
 
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.
 
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,
 
You must log in or register to reply here.
Back
Top