Lookup the 2nd last entry

[guitarrocks89]

Hi guys,

Please help. I require a formula that allows me to lookup an item's expiry date with reference from another spreadsheet. I'm able to get the latest's expiry date, but i require the 2nd latest expiry date too. Is this possible?

Please let me know if i need to attach my worksheet

Thanks in advance(:

[khamilton]

See if this helps!!!

http://www.excelforum.com/excel-gene...-a-column.html

[guitarrocks89]

thanks for the prompt reply, but it didn't work i've pasted the worksheet. the batch 1 expiry date should show the 2nd latest expiry date from the orders worksheet.