Match data and extract an adjacent result.

%3CLINGO-SUB%20id%3D%22lingo-sub-2265671%22%20slang%3D%22en-US%22%3EMatch%20data%20and%20extract%20an%20adjacent%20result.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2265671%22%20slang%3D%22en-US%22%3E%3CP%3EHere%E2%80%99s%20what%20I%E2%80%99%2C%20trying%20to%20do.%3C%2FP%3E%3CP%3ELookup%20data%20from%20%3CU%3EColumn%20C%3C%2FU%3E%20in%20%3CU%3EColumn%20R.%3C%2FU%3E%26nbsp%3B%20When%20found%20in%20%3CU%3EColumn%20R%3C%2FU%3E%2C%20take%20the%20adjacent%20data%20from%20%3CU%3EColumn%20S%3C%2FU%3E%20and%20place%20it%20in%20%3CU%3EColumn%20K%3C%2FU%3E.%3C%2FP%3E%3CP%3EI%20have%20not%20been%20able%20to%20find%20any%20similar%20example%20using%20match%2C%20vlookup%2C%20or%20index.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2265671%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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.

 

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

@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.

@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.