Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

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

Copper 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
best response confirmed by lmk001 (Copper Contributor)
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.  

1 best response

Accepted Solutions
best response confirmed by lmk001 (Copper Contributor)
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.

View solution in original post