If then

[PlzHelpMe]

Hello everyone, hoping one of you smart people can help with my conundrum. I'm using the formula below as an "if then," but getting an error (Invalid Name) every time. Basically I want to return one index/match if cell A2 is "Late" or another index/match if A2 is "Early." Please help me...

=IF(A2=Early, (INDEX(Data!$B$2:$K$21, MATCH("Average",Data!$C$2:$C$21,), MATCH("Cure Per Connect",Data!$B$2:$K$2,))), IF(A2=Late, (INDEX(Data!$B$2:$K$21, MATCH("Late",Data!$C$2:$C$21,), MATCH("Cure Per Connect",Data!$B$2:$K$2,0)))))

 

[shg]

Unless those are named ranges or named constants, they need to be in quotes:

=IF(A2="Early", INDEX(Data!$B$2:$K$21, MATCH("Average", Data!$C$2:$C$21, 0), MATCH("Cure Per Connect", Data!$B$2:$K$2, 0)),
 IF(A2="Late",  INDEX(Data!$B$2:$K$21, MATCH("Late",    Data!$C$2:$C$21, 0), MATCH("Cure Per Connect", Data!$B$2:$K$2, 0))))

 

[PlzHelpMe]

Works perfectly! Thank you for your help. Make it a great day!

 

[shg]

You're welcome.