Error in formula

Can you please tell me why it gives error? I am trying to print the correspondent number from sheet2
Who is Participating?
Vijaya KumarCommented:
NorieVBA ExpertCommented:
Try this.

Vijaya KumarCommented:
Try this one


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
mustish1Author Commented:
how to change #NA with zero if not found?
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.