Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron St Jean Ron St Jean is offline
external usenet poster
 
Posts: 6
Default Vlookup

I am trying to look up 2 dates (start and finish) I am using vlookup but it
seems that I can only have one date. I have created a calendar for my
project. Here is the formula I am using that works for one date. How would I
modify it to use both dates?
=VLOOKUP($D2,$CA$2:$CA$38,1,FALSE)
I am trying to make it so that it would be something like
=VLOOKUP($D2:E2,$CA$2:$CA$38,1,FALSE)