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