Forum Discussion
Solved
Formula help: if two cells match on different sheets, display value of adjacent cell...
Couldn't quite explain this in the title.... perhaps best just show an example. Sheet 1: Here I have the "ledger codes", which are also shown next to each transaction on Sheet 2. Sheet...
=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.
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!