Date Query - Look up or IF????????

  • Thread starter Thread starter nicknjohn
  • Start date Start date
N

nicknjohn

G'day

We are trying to write a function to work out if a date range (star
Date - Now) pass over a set of specific dates. If the date rang
crosses a 'Spot Date' then we need to return the result '1', if th
range passes 2 'Spot dates we need to return the result '2' and so on.

we have put the specific 'spot dates' into a table of their own t
'look up' to, but are scratching our heads furiously trying to find th
correct function to complete this task.

Any help would be appreciated.

John n Nick:confused
 
Hi
not completely sure but try the following:
- column A: your dates in asceding order
- column B: associated values
- cell C1: Date to lookup
- cell D1: _formula:
=VLOOKUP(C1,A1:B100,2,1)
 
Back
Top