Forum Discussion

lmk001's avatar
lmk001
Copper Contributor
Oct 29, 2019

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...
  • SergeiBaklan's avatar
    Oct 29, 2019

    lmk001 

    It's custom format like this

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

Resources