I have an spreadsheet where I want to compare values between two columns and return the value from the relating row in a third column. If A1 is found in B1:6, return value in column C from the row in which A1 was found.
Is this possible? I have a macro that does this, but returns only a statement in a chosen column, I would need it to return the corresponding value from column D - and I'm really not good at this!
Any help would be much appreciated!
A B C D
2 5706631000253 5706631000253 Text 1 Text1
3 5706631000376 5706631000260 Text 2
4 5706631000482 5706631000338 Text 3
5 5706631002301 5706631000376 Text 4 Text 2
6 5706631003643 5706631000390 Text 5