#FIELD Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2338331%22%20slang%3D%22en-US%22%3E%23FIELD%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338331%22%20slang%3D%22en-US%22%3E%3CP%3ECurrently%20making%20a%20dividend%20spreadsheet%20comprised%20with%20stocks%20and%20ETFs.%20Everything%20was%20going%20smoothly%20until%20I%20got%20a%20%22%23FIELD!%22%20error%20under%20my%20Industry%20column%20for%20all%20my%20ETFs%20using%20the%20formula%3A%20%3DB6%23.Industry.%20The%20Industries%20for%20the%20stocks%20were%20found%20and%20filled%20by%20excel%20but%20not%20the%20ETFs.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2338331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339507%22%20slang%3D%22en-US%22%3ERe%3A%20%23FIELD%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339507%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B.%20I'm%20guessing%20that%20means%20there%20is%20no%20datatype%20for%20ETFs%20then%20at%20this%20time%20or%20I'd%20need%20to%20get%20the%20data%20some%20other%20way.%20Not%20having%20excel%20show%20what%20industry%20my%20ETFs%20fall%20under%20isn't%20a%20huge%20issue%20as%20everything%20else%20(prices%2C%20percentages%20etc)%20revolving%20around%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339483%22%20slang%3D%22en-US%22%3ERe%3A%20%23FIELD%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339483%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048811%22%20target%3D%22_blank%22%3E%40DeshiG%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EField%20error%20means%20that%20datatype%20doesn't%20exist%20in%20the%20records.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Currently making a dividend spreadsheet comprised with stocks and ETFs. Everything was going smoothly until I got a "#FIELD!" error under my Industry column for all my ETFs using the formula: =B6#.Industry. The Industries for the stocks were found and filled by excel but not the ETFs. 

2 Replies

Hi @DeshiG,

 

Field error means that datatype doesn't exist in the records.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Thanks @Faraz Shaikh . I'm guessing that means there is no datatype for ETFs then at this time or I'd need to get the data some other way. Not having excel show what industry my ETFs fall under isn't a huge issue as everything else (prices, percentages etc) revolving around it works.