Forum Discussion
Danil Lopukhov
May 26, 2017Copper Contributor
solved
solved
2 Replies
- Logaraj SekarSteel Contributor
- Logaraj SekarSteel Contributor
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.