Forum Discussion

2 Replies

  • I opened that file.

     

    All Sheet names are in English.

     

    But in the Sheet 'expenses RFID', from Cell J106 to J115, J130 to J133,

     

    I added ",0" to VLOOKUP formula.

     

    i.e

    "=VLOOKUP(H109,Норм_содержания,3)" replaced with

    "=VLOOKUP(H109,Норм_содержания,3,0)"

     

    Now, all '#N/A' are disappeared.

     

    Refer 'PVP and AK' sheet, Correct formula in cells T204, T205.

     

    It will be solved.

Resources