Forum Discussion
Formula help: if two cells match on different sheets, display value of adjacent cell...
=VLOOKUP(A2,sheet1!$A$1:$B$7,2,FALSE)
Maybe with vlookup as shown in the attached file. With Office365 or 2021 you can use xlookup as well.
=VLOOKUP(A2,sheet1!$A$1:$B$7,2,FALSE)
Maybe with vlookup as shown in the attached file. With Office365 or 2021 you can use xlookup as well.
It worked a charm, thanks again! Saved me a lot of time. I'm sure the question has been answered before, but I didn't know how to search for it, so I'm very grateful for your help.
I'll try that when I'm back in the office tomorrow... for now I just wanted to say thank you very much. The "SVERWEIS" had me confused for a second... vielen Dank!
I don't have xlookup as we're still on Office 2016, but hopefully I'll be able to pretty much paste the code and get the results!