Vlookup function does not work

[alljewel]

Dear,

My "vlookup" function doesn't work while I try to fetch a value from Sheet # "IS Nahid" to Sheet # "Article Master" in "C" column.


Please help me solving it.

[63falcondude]

Try this instead (assuming that you want to return column I):

=IFERROR(INDEX(IS_Nahid!I:I,MATCH(A2,IS_Nahid!B:B,0)),0)

[alljewel]

Dear,

63falcondude,

Well done. It works like miracle.

Sincerely yours,
Md. Nahidul Islam

[63falcondude]

You're welcome. Happy to help!