Conditionally pull data from another list Closed

Question

Dear All, 

I need help in the following matter urgently, please can anyone help?

I have an Excel workbook containing a list of file names in Column E (*.wav). Let's name it "Calllog.xls". 

I have another workbook named "tracker.xls" containing the same .wav file names (not in the same order) in Column "C". The column "D" in this tracker.xls workbook contains information on the contents of the voice file input manually in text (for example, "This file contains background noise" after hearing the voice file...

I need a macro or code or formula, that will "auto-populate" Column "F" in the Calllog.xls workbook by matching the file names in the tracker.xls (Column "C") and copy and paste the corresponding text data from the same row in Column "D" of the Calllog.xls.

Please can anyone help?

Thanks and regards,

EskagSMS
India

Configuration: Windows XP / Opera 9.80

Mehedad · Answer

I think you can use VLOOKUP in the Column F of Callog.xls

Incase you don't know what VLOOKUP is, apply the below formula in F2 of Callog.xls:

=VLOOKUP(E2,'[Tracker.xls]Sheet1'!$C:$D,2,FALSE)

Both the workbooks have to be open when the formula is entered or else you need to specify the File Path in the formula. And the column (Col C) in Tracker.xls has to be sorted in Ascending order (Sort A to Z).

Please check the sheet name in Workbook Tracker.xls and change accordingly in the formula.

Let us know if it worked.

eskagsms · Answer

That worked great even without not sorting. Thanks a lot.

Conditionally pull data from another list

2 responses

Similar discussions

Subscribe To Our Newsletter!