How do I get Excel to match content of cell and perform an action?

[nyancat]

[FONT=NettoOT, Arial, sans-serif]I will have multiple Excel files that have very similar data in the first column (Company Names), how do I get Excel to find out what the information is in the first column and then post it's website in the 2nd column from a pre-populated list? I have hundreds of Company Names per Excel sheet.

For example I want to search in column one for the company "Apple", if "Apple is found, "http://www.apple.com" will display in the 2nd column. Then if "Microsoft" is found, "http://www.microsoft.com" will display in the 2nd column.


[/FONT]

 

[ArthriticPanda]

Hi nyancat,

You could create your master list of company names and web addresses on sheet2 and then use the INDEX MATCH function in an IF statement to put the relevant site against the company name which is typed in a certain cell.

Put the following formula in column B and copy down:

=IF(A1=$F$1,INDEX(Sheet2!$B$1:$B$2,MATCH(Sheet1!$F$1,Sheet2!$A$1:$A$2,0)),"")

Excel 2010
	A	B	C	D	E	F
1	Company A				Search:	Apple
2	Company B
3	Company C
4	Microsoft
5	Company D
6	Apple	http://www.apple.com
7	Company E
Sheet1

Excel 2010
	A	B
1	Microsoft	http://www.microsoft.com
2	Apple	http://www.apple.com
Sheet2

Hopefully this will be of some use.

AP

 

[nyancat]

Hi AP,

Is there anywhere I can download a sample of your excel sheet? I tried to replicate your instructions, but it's not working for me.

Thank you so much.