Forum Discussion
Match data and extract an adjacent result.
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
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.
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.
- I found it! I've been close several times and then, click!
=VLOOKUP($D12,$R$12:$S$51,2,FALSE)
