Match data and extract an adjacent result.

[Kid1343]

Here’s what I’, trying to do.

Lookup data from Column C in Column R.  When found in Column R, take the adjacent data from Column S and place it in Column K.

I have not been able to find any similar example using match, vlookup, or index.

[#2]

I found it! I've been close several times and then, click!
=VLOOKUP($D12,$R$12:$S$51,2,FALSE)

[#3]

@Kid1343 

If you are using Excel 365 then a better formula would be

= XLOOKUP(ColumnC, ColumnR, ColumnS, "")

placed in the first cell of ColumnK.  That give a dynamic range which is more consistent with the intention of 365 and differs from traditional spreadsheet techniques.

[#4]

@Peter Bartholomew 

Thank you for your response.  I don't have that version of Excel so it didn't work.  I like it because it's simpler.  I am subscribing to Microsoft and thought I was using 365, but I guess I'm not.