Hi, I have done a search for this not really following results so I have mocked up an Excel sheet to try and illustrate what it is I need to be able to do. My problem is that I need to extract the data for column C on 'Nearest Pupils Attending School' from Column E of 'Actual vs School Table' where the values in column A of 'Nearest Pupils Attending School' matches the values in Columns A and C on 'Actual vs School Table'.
I hope that is clear; any assistance thankfully received.
Thanks
Bookmarks