R
Ron St Jean
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)
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)