Apr 10 2021 01:01 PM
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.
Apr 10 2021 01:11 PM
Apr 10 2021 02:40 PM
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.
Apr 17 2021 09:15 PM
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.