I amtrying to use Vlook-up but maybe it is not the right query to use.
I have attached a dummy file to try and explain what I need to do which is:
The Vlook-up looks up [column A from sheet2] Column B in Sheet1 and returns the detail from column C in Sheet1
However, I need to make it put only the word 'Pending' in Column B on Sheet2 and 'Open' in Column C on this sheet.
So, in this example 'a123456' has two records on Sheet 1, One is Pending one is Open
'x897456' and 'e654125' have no records on Sheet1 therefore they are Blank
The remainder have either 'Pending' or' Open'.
Maybe this is not possible!!!