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