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
Shorten Formula 1
Filtering data from a non-continuous list 3
Using Project to plan multiple proposals 2
Resource plans disappear when restoring projects/proposals from ba 3
Proposal not converting to a Project 2
Conditional format or chart to show trend week by week 0
Viewing of Proposal (under Proposals and Activities) work under My 3

Top