index using a column to the left

Column B contains the range I will evaluate and then I want to bring the value in column A (to the left), how should the formula be written?

Thanks,
JP
easycapitalAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
To match C1 in column B and return the respective value from column A

=INDEX(A:A,MATCH(C1,B:B,0))

regards, barry
0
 
easycapitalAuthor Commented:
Perfect.
JP
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.