Hoping one of you experts can help.
I have two excel worksheets that i need to compare data between then bring throgh one of the fields to the other sheets. eg.
I require on sheet 1 values in A & C to check and match values A & D in Sheet 2
Sheet 1 A = Sheet 2 A
Sheet 1 C = Sheet 2 D.
If the test is correct i need the corresponding value in sheet 2 colum z to be brought to sheet 1 most likely in the form of a vlook.
hope the above is clear.