Index/Match & Vlookup Help!

I am creating a scorecard for the different offices that we visit. More often than not, we visit those offices a couple times a year. So I have a separate table that we schedule our visits chronologically, that I would like to have dates auto-populate into the scorecard itself based of a couple of matching criteria. Here's what I need:

if A3= any of AK3:AK43, and if AM on the same row is "Follow Up", then retrieve data from AL on the same row

I have tried several things and I get so close, but it's pulling data regardless if AM = "Follow Up"

I can get screenshots if needed.

Thanks in advance!

Something like
=INDEX($AL$3:$AL$43,MATCH(1,($AK$3:$AK$43=A3)*($AM$3:$AM$43="Follow Up"),0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Perfect that works! What if it says "Follow Up" or "Subsequent"?

Wow I should have asked you guys a long time ago. Everything works beautifully now.

Thanks again!

How about
=INDEX($AL$3:$AL$43,MATCH(1,($AK$3:$AK$43=A3)*(($AM$3:$AM$43="Follow Up")+($AM$3:$AM$43="subsequent")),0))
Also needs CSE

Originally Posted by Fluff13

How about
=INDEX($AL$3:$AL$43,MATCH(1,($AK$3:$AK$43=A3)*(($AM$3:$AM$43="Follow Up")+($AM$3:$AM$43="subsequent")),0))
Also needs CSE

Thanks! Works like a charm.

You're welcome & thanks for the feedback