Vlookup - query

Hello

Can someone tell me why in the attached document sheet 2 cell F5 is not returning the value of 1 (relating to sheet 1 cell c8) when using the vlookup function?

Thanks
Rob
Excel-question---vlookup.xlsx
rob700Asked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Your lookup table range in the formula was column A only, should be minimum A:C  since you want the 3rd column data

=VLOOKUP(C5,Sheet1!A:C,3,FALSE)
0
 
rob700Author Commented:
Fantastic, stupid mistake.

Thank-you!
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.