SOLVED
Home

Formula Help: Formula Calculates but I get General as value returned. See attached file.

%3CLINGO-SUB%20id%3D%22lingo-sub-962887%22%20slang%3D%22en-US%22%3EFormula%20Help%3A%20Formula%20Calculates%20but%20I%20get%20General%20as%20value%20returned.%20See%20attached%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151515i919722825FF179D7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3BThe%20Part%20Number%20is%20a%20drop%20down%20and%20so%20is%20the%20Field%20Name.%26nbsp%3B%20I%20Keep%20getting%20'General'%20as%20the%20value%20returned.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Formula%20is%3A%20%3DINDEX(PartsTable%2CMATCH(K2%2CPartsTable%5B%23Headers%5D%2C0)%2CMATCH(K1%2CPartsTable%5BNumber%5D%2C0))%3C%2FP%3E%3CP%3EPartsTable%20is%20the%20whole%20table.%26nbsp%3B%20When%20I%20click%20the%20Fx%20button%20I%20see%20that%20my%20formula%20is%20correct%26nbsp%3B%20but%20it%20shows%20as%20'General'%20on%20the%20sheet.%26nbsp%3B%20%26nbsp%3B%20Why%20is%20this%20happening%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDivisionDescriptionQuantityCostTotal%20CostRetailGross%20MarginNumber%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EParts%20Database%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EGangley%20Pliers%3C%2FTD%3E%3CTD%3E57%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2010.47%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20596.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2017.95%3C%2FTD%3E%3CTD%3E71.4%25%3C%2FTD%3E%3CTD%3ED-178%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EHCAB%20Washer%3C%2FTD%3E%3CTD%3E856%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%200.12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20102.72%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%200.25%3C%2FTD%3E%3CTD%3E108.3%25%3C%2FTD%3E%3CTD%3EA-201%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EFinley%20Sprocket%3C%2FTD%3E%3CTD%3E357%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201.57%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20560.49%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202.95%3C%2FTD%3E%3CTD%3E87.9%25%3C%2FTD%3E%3CTD%3EC-098%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E6%22%20Sonotube%3C%2FTD%3E%3CTD%3E86%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2015.24%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%201%2C310.64%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2019.95%3C%2FTD%3E%3CTD%3E30.9%25%3C%2FTD%3E%3CTD%3EB-111%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3ELangstrom%207%22%20Wrench%3C%2FTD%3E%3CTD%3E75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2018.69%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%201%2C401.75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%2027.95%3C%2FTD%3E%3CTD%3E49.5%25%3C%2FTD%3E%3CTD%3ED-017%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EThompson%20Socket%3C%2FTD%3E%3CTD%3E298%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203.11%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20926.78%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205.95%3C%2FTD%3E%3CTD%3E91.3%25%3C%2FTD%3E%3CTD%3EC-321%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3ES-Joint%3C%2FTD%3E%3CTD%3E155%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%206.85%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%201%2C061.75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%209.95%3C%2FTD%3E%3CTD%3E45.3%25%3C%2FTD%3E%3CTD%3EA-182%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3ELAMF%20Valve%3C%2FTD%3E%3CTD%3E482%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204.01%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%201%2C932.82%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%206.95%3C%2FTD%3E%3CTD%3E73.3%25%3C%2FTD%3E%3CTD%3EB-047%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-962887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963002%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3A%20Formula%20Calculates%20but%20I%20get%20General%20as%20value%20returned.%20See%20attached%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434928%22%20target%3D%22_blank%22%3E%40lmk001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20custom%20format%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20436px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151745iAD1318190A604662%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2B1%20on%20the%20cell%20and%20apply%20General%2C%20number%20or%20currency%20format%2C%20the%20one%20which%20you%20need.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963868%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3A%20Formula%20Calculates%20but%20I%20get%20General%20as%20value%20returned.%20See%20attached%20file.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20Thank%20you!%26nbsp%3B%20I%20figured%20it%20was%20something%20easy%20to%20figure%20out.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
lmk001
New Contributor

clipboard_image_0.png The Part Number is a drop down and so is the Field Name.  I Keep getting 'General' as the value returned.  

My Formula is: =INDEX(PartsTable,MATCH(K2,PartsTable[#Headers],0),MATCH(K1,PartsTable[Number],0))

PartsTable is the whole table.  When I click the Fx button I see that my formula is correct  but it shows as 'General' on the sheet.    Why is this happening?  Thanks.

 

DivisionDescriptionQuantityCostTotal CostRetailGross MarginNumber

Parts Database       
4Gangley Pliers57 $   10.47 $       596.79 $   17.9571.4%D-178
3HCAB Washer856 $     0.12 $       102.72 $     0.25108.3%A-201
3Finley Sprocket357 $     1.57 $       560.49 $     2.9587.9%C-098
26" Sonotube86 $   15.24 $   1,310.64 $   19.9530.9%B-111
4Langstrom 7" Wrench75 $   18.69 $   1,401.75 $   27.9549.5%D-017
3Thompson Socket298 $     3.11 $       926.78 $     5.9591.3%C-321
1S-Joint155 $     6.85 $   1,061.75 $     9.9545.3%A-182
2LAMF Valve482 $     4.01 $   1,932.82 $     6.9573.3%B-047
2 Replies
Solution

@lmk001 

It's custom format like this

image.png

Press Ctrl+1 on the cell and apply General, number or currency format, the one which you need.

@Sergei Baklan  Thank you!  I figured it was something easy to figure out.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies