Error in formula

Can you please tell me why it gives error? I am trying to print the correspondent number from sheet2
testdata.xlsx
mustish1Asked:
Who is Participating?
 
Vijaya KumarCommented:
=IFERROR(VLOOKUP(B3,Sheet2!A4:B8,2,0),0)
0
 
NorieVBA ExpertCommented:
Try this.

=VLOOKUP(B3,Sheet2!A:B,2,0)
0
 
Vijaya KumarCommented:
Try this one

=VLOOKUP(B3,Sheet2!A4:B8,2,0)

first parameter was what you going to look
second parameter in the vlookup is table array(i.e=> A,Bcolumn) so u need to specify range like A:B
third one is index if u have A,B,C u need result of C then it ill be 3
fourth one is exact match or approximate match
0
 
mustish1Author Commented:
how to change #NA with zero if not found?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.