Excel Problem... Expert pls

[Adeawan]

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.

[syar]

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

[Adeawan]

please fill proper formula in bracket

[syar]

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