Formula for which file containing string

[ItalianPlatinum]

Hello - I have two files where I use for data. the data could reside in either file but never both. All I am looking for is a way or formula to tell me which file was used for my data. see below for example:

File 1: C:\Users\M\Desktop\Current MV stocks e.csv
File 2: C:\Users\M\Desktop\Current MV stocks T.csv

Column B is used for the finding formula. and Column N is where I would like to place the formula. if file 1 say file 1 and if file 2 say file 2. Column E is where I used the data. Thanks in advance!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Company	Symbol	Date of Purchase	Industry	Current Market Value	% of Portfolio		Cost	Unrealized Gain/Loss	Dividends YTD	ROI	LT or ST?		Formula needed
2	XXXXXX	AAA	XXXXXX	XXXXXX	XXXXXX	XXXXXX		XXXXXX	XXXXXX	XXXXXX	XXXXXX	XXXXXX
3	XXXXXX	BBB	XXXXXX	XXXXXX	XXXXXX	XXXXXX		XXXXXX	XXXXXX	XXXXXX	XXXXXX	XXXXXX
4	XXXXXX	CCC	XXXXXX	XXXXXX	XXXXXX	XXXXXX		XXXXXX	XXXXXX	XXXXXX	XXXXXX	XXXXXX
5	XXXXXX	DDD	XXXXXX	XXXXXX	XXXXXX	XXXXXX		XXXXXX	XXXXXX	XXXXXX	XXXXXX	XXXXXX
6	XXXXXX	EEE	XXXXXX	XXXXXX	XXXXXX	XXXXXX		XXXXXX	XXXXXX	XXXXXX	XXXXXX	XXXXXX
Sheet1