Hi All,

I currently have the following VLOOKUP which queries another sheet
within the workbook that contains a set of data from a query. This
works fine until recently when the data system introduced version
controls on records. Now there could be two lines for the same
reference (i.e. B11, in this example, could have reference to record
1. But record 1 could now contain a line within the Data sheet at
line 5, for version 1, and line 28, for version 2 etc...etc...).

What I'd like to be able to do is to say within the following bring
back the last row that contains the entry defined within B11, almost
to have the formula working from the bottom of the range upwards or
any other means to achieve this?

=IF(ISERROR(VLOOKUP($B11,Data!OpenRecords,
2,FALSE)),"",VLOOKUP($B11,Data!OpenRecords,2,FALSE ))

Thanks in advance, Al.