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
View best response
It's custom format like this
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.