I need your help with a lookup. I have a spreadsheet of contract
proposals. I populate this spreadsheet with my company's proposals
and
the vendor's proposals. As new proposals come in, I keep updating the
spreadsheet. I want to be able to do a lookup of our most recent
proposal spend and a separate lookup of the vendor's most recent
proposal spend. Moreover I would also like to do lookups of the 2nd
most recent proposal spend. Below is an example

Our Proposal 1 Vendor Proposal 2 Our Proposal
2 Vendor Proposal 2 Our Proposal 3
Spend Trend Spend Trend Spend
Trend Spend Trend Spend Trend


How would I do this? As always, I appreciate your help