Look-Up Function

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.
 
N

Natalie

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

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

Excel PRICE function: How does it compute Issue Date of the Security 5
Date Range Formular 5
Find Last entry for Col in Multi column array using cell from another array. 1
Worksheet Function required 2
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
using dates for lookup 2
Conditional PRODUCT or SUM 9
How to Use two search criteria in one array. 2

Top