Hi All,


I am trying to a VLOOKUP/MATCH on data that for 'this month' and display it on another worksheet. First problem is extracting only data from the 'last posted' coloumn which is this month. Second problem is doing a backwards LOOKUP :S

See the attached for clarity. Hope you can help.

VLOOKUP+MATCH PROBLEM.xls