Industry

Returns the industry classification for a company. Industries are more specific than sectors and group companies with similar business activities.

Sector vs Industry Example

Stock	Sector	Industry
AAPL	Technology	Consumer Electronics
NVDA	Technology	Semiconductors
MSFT	Technology	Software - Infrastructure
GOOGL	Communication Services	Internet Content & Information

Common Industries

Technology sector includes industries like:

Consumer Electronics
Semiconductors
Software - Infrastructure
Software - Application
Information Technology Services

Financial Services sector includes:

Banks - Diversified
Insurance - Diversified
Asset Management
Credit Services

Examples

=Industry("AAPL")

Returns "Consumer Electronics"

=Industry("NVDA")

Returns "Semiconductors"

=Industry("JPM")

Returns "Banks - Diversified"

=Industry(A1)

Symbol from cell reference

When to Use

Detailed company classification
Finding peer companies
Industry-specific analysis
Comparing companies in the same industry
Building industry-focused watchlists

When NOT to Use

Scenario	Use Instead
Need broad classification	`Sector()`
Need company peers	`peers()`
Need full description	`CompanyProfile()`
Need SIC classification	`SIC_code()`

Common Issues & FAQ

Q: What's the difference between Sector and Industry? A: Sector is broader (e.g., "Technology"), while Industry is more specific (e.g., "Semiconductors"). A sector contains multiple industries.

Q: Why might Industry return "NA"? A: This can happen for:

ETFs (no industry classification)
ADRs and foreign stocks
Very new listings
Invalid symbols

Q: Can I screen for stocks by industry? A: Yes, use the MarketXLS Screener to filter by specific industries.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

MarketXLS Excel Add-in Tutorial - How to Use Industry and Other Financial Formulas

▶

How does MarketXLS work?