Help with Lookup

  • Thread starter SanCarlosCyclist
  • Start date
S

SanCarlosCyclist

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Lookup 0
Filtering data from a non-continuous list 3
Shorten Formula 1
Formatting question with Round 3
Replace "Cell based" formulas with "word-based" formulas 3
How to reference one column against another 10
Missing data when using TREND function 0
Using Project to plan multiple proposals 2

Top