I want to be able to enter a reference no. In ‘Sheet 1’ A1
Then search for that number in column D in Sheets 2,3,4 etc. and display the result of column E of the same row.
Is this possible and could someone help please?
Thanks for any help
Then search for that number in column D in Sheets 2,3,4 etc. and display the result of column E of the same row.
Is this possible and could someone help please?
Thanks for any help