Vlookup??

[mcintoshmc]

I currently run a report on a weekly basis that will show all of our open positions. I then copy and paste that report into my spreadsheet, so I can run any vlookup to suits my needs.

Each week when copying and pasting the report into my sheet, I do not overwrite the previous data, I paste it at the bottom. The reason I do this, is because I don't want info for older/closed positions to go away, and this report is only for open positions.

The problem I am running into is that a position can be created one week, and in the course of time, certain details about the position can be changed. Although, I am recording the changes when pasting the report that week, the vlookup is not always picking up those changes.

If I were to add a column that reflects the date the info was run, is there a formula I can use other than a vlookup, that would pull the information from the most current date? The identifier is the requisition number.

To add: I occasionally remove duplicates, so that the sheet does not get to big, but when I do that, it removes the newer version and keeps the original.

 

[Yongle]

This is a simple solution but only works if your data is sorted from earliest in row2 to most recent in last row
It finds the last match in the range - so the one you want must be the last of its kind!

a LOOKUP formula to return the row number of the LAST match in column A for "cd"
=LOOKUP(2,1/(A:A="cd"),ROW(A:A))

which can be used with INDEX to return the value in column F corresponding to that match
=INDEX(F:F,LOOKUP(2,1/(A:A="cd"),ROW(A:A)))

If you are interested in understanding how it works here is an excellent tutorial on the LOOKUP function