PDA

View Full Version : Search data and return latest status based on date & time



Panda
04-13-2011, 01:33 AM
Hi There,

I am trying to wrote an expression/formula to return whether a part is in the cabinet or not. My spreadsheet has 3 columns, 1 containing a part number, 1 stating whether it is in or out of the cabinet and the last one . However, the same part can be booked in and out more then one time. Is there a way I can tweak the vlookup function to look for the part number and return the latest occurrence of the part status?

Attached is an example of the data.

Can anyone help me?

Thanks in advance