That's good. Could you spare a moment to click the YES button in that response?

The expression, with the range lookup param omitted, sets it for an approx
match to be found in col B for the lookup date in A1. This requires that the
table array be sorted in ascending order by its 1st col, ie by col B. Pl
check Excel's HELP on VLOOKUP for more details.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"-Julie" wrote:
Thanks, that works! But can you translate that for me? Tell me what the
formula is looking at once it gets to column B. This will help me in the
future.