VLOOKUP to return value found in 1 of 4 columns to a different column in same row

Hello,

I am trying to use VLOOKUP to return a value found in one of four columns to the "end" column where I want the data to display. The table array is matching one corresponding value from one column to the adjacent column. I am able to get the value to display if I only reference one cell, like this:

=VLOOKUP(C9,$A$2:$B$4,2,FALSE)

However, you'll see in the attached worksheet that I essentially want the VLOOKUP to search across four columns, like this:

=VLOOKUP(C9:F9,$A$2:$B$4,2,FALSE)

But the error in the cell is: #VALUE!

Additionally, I want to be able to drag the formula down multiple rows, only displaying one corresponding value. Perhaps VLOOKUP isn't the correct formula? I would appreciate any and all help. Thank you!