salam, muje ms excel mai aik prob ka asamna hai kindly koi expart pataye k easay kaisa solve kia jaye,,,
how to vlookup formula result #n/A. replace with any symbol.
salam, muje ms excel mai aik prob ka asamna hai kindly koi expart pataye k easay kaisa solve kia jaye,,,
how to vlookup formula result #n/A. replace with any symbol.
salam::
u can use if and iserror combination e.g.
=IF(ISERROR(VLOOKUP()),"A",VLOOKUP())
replace a with your desire output. Or custom format the cell
regards
please fill proper formula in bracket
Brother Vlookup ka formula tu jo aap use kar rahe hain sheet m whoi rahe ga. m n sirf aap ko example d ha ka aap if aur iserror k combination sa error ko hide kar sakte hain. agar aap apne sheet share kar dain tu phir m proper formula laga donga. ya aap apna vlookup ka formula share kar lain tu bhe theek ha.
m n sirf example k leye if, iserror k sath vlookup() ka formula bataya ha.
regards
Bookmarks