"Ian_W-at-GMail" wrote in message
oups.com...

Hi Sandy;

Your formula works!!!! I just tried it in my spreadsheet and I get
the correct values (Unit Price) returned based on the transaction
date. And you were correct, I had a type-O in the date field (s/b
2/2/07).

Thank you soooo much for your help!!! I will have to take some time
to figure out how your nested formula works....

- Ian -


Hi Ian,

Thanks for the feedback. I will let you figure out how it works yourself
because I find that that is where I learn the most - figuring out how the
formulas of the experts around here work - I only wish that I could remember
them when I need it again!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk