Why my vlookup does not work

Why my "Vlookup" function does not work in the worksheet if I want to fetch data from sheet "IS_Nahid".

I want to fetch data from sheet "IS_Nahid" column "I" to sheet "Article Master" in column "C". But "vlookup" doesn't work here.

I had to use "Match & Index" Instead.

Why "vlookup" doesn't work?

You are trying to get data from the table vlook, which you have defined as:

=IS_Nahid!$A$2:$I$1909

VLOOKUP always looks in the left-most column of the table to try to find a match, but your column for the lookup values (Article) is column B, so you need to change your named range to cover:

=IS_Nahid!$B$2:$I$1909

and you will need to change the 9 to 8, as column I is 8 columns to the right of column B. Here's the amended formula in C2 without using named ranges:

=IFERROR(VLOOKUP(A2,IS_Nahid!$B$2:$I$1909,8,FALSE),0)

Hope this helps.

Pete