• 544K Members
• 3,315 Online
• 649K Conversations
SOLVED

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

Highlighted
Occasional Contributor

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

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 4 Gangley Pliers 57 \$   10.47 \$       596.79 \$   17.95 71.4% D-178 3 HCAB Washer 856 \$     0.12 \$       102.72 \$     0.25 108.3% A-201 3 Finley Sprocket 357 \$     1.57 \$       560.49 \$     2.95 87.9% C-098 2 6" Sonotube 86 \$   15.24 \$   1,310.64 \$   19.95 30.9% B-111 4 Langstrom 7" Wrench 75 \$   18.69 \$   1,401.75 \$   27.95 49.5% D-017 3 Thompson Socket 298 \$     3.11 \$       926.78 \$     5.95 91.3% C-321 1 S-Joint 155 \$     6.85 \$   1,061.75 \$     9.95 45.3% A-182 2 LAMF Valve 482 \$     4.01 \$   1,932.82 \$     6.95 73.3% B-047
2 Replies
Highlighted
Solution

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

It's custom format like this

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

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

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