Hm, hard one. I don't think I've had that result in more than a decade.
There are two upions that work, done correctly w/ fault. One is for intermediate users, #HLookup 1), #VLookup, or #XLookup, the other for fairly advanced users, #PowerQuery 2).
(I'm assuming that copy and paste has not been a top choice for you either. 😉)
1)
https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f
2) https://m.youtube.com/watchhttps://m.youtube.com/watch?v=rNlie4RGdCU