Look-Up Function

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

I have 2 columns of data: date and price. I'd like to
create a cell which will return the price based on the
last date that price is entered. ie. I will pre-entered
date up till Dec-2005, but prices may only be available
up till Nov-2003.

Can this be done?

Thank you.
 
wow, amazing!!! all you guys giving out solutions, you
work for Microsoft? How can you be so proficient?!?
 
Back
Top