LOOKUP the nearest previous similar value

[gregersdk]

Hello World!

I have a conundrum I hope you can help with.

I have a list of entries about people entering and leaving buildings in a long dataset. Since the dataset is with all the buildings mixed, I need a way to look up the last entry of someone entering the building from the cell where the person leaves the building. Basically I need a lookup function that starts from my exit cell and looks through previous entries until it finds a match.

The two datastrings in the file (column D) look like this:

CTR HID iCLASS 26 Bit 14652 (NAME3 VPA - COM2) retning: ind (entering a building called VPA)
CTR HID iCLASS 26 Bit 14652 (NAME3 VPA - COM2) retning: ud (leaving a building called VPA)

Anyone have any suggestions?


Thank you,
GregersDK

[bmouse]

Invert the list and use VLOOKUP normally. Possible?