Hi, @Emily Reed ,

Can you share your current formula that's returning #UPARSEABLE so we can see if it's just a syntax error? You might be closer than you think.

Hi, @Emily Reed ,

This one took some trial and error, but figured it out. Try this calculation, and below it, I'll explain what you're referencing in each parameter so you'll be able to repeat it.

=INDEX({[2021 IC Speaker Presentations Range DATE], MATCH([Session Title]@row, {2021 IC Speaker Presentations Range 2},0))

The {test2 dategrabber} range in my test is this single column of Date Submitted in my test field (this would be the equivalent of your 2021 IC Speaker Presentations sheet. This is where we're searching for the answer.

Then, we'll look to match up the titles against titles that appear in the Speaker Database,

and we'll be searching against the array represented by the columns in your 2021 IC Speaker Presentations Sheet that looks like this:

INDEX,MATCH works a bit differently from VLOOKUP in that you first define where you will look for the answer (the date you want to pull over), and then you define how you'll find it by defining the Match criteria - what am I looking for, and what is the range that contains my match indicator (far left column) and my defined answer range that is identified in the INDEX criterion (could be last, but doesn't have to be as long as it's to the right of the match indicator). The 0 represents that you require an exact match. 1 requires that your data be sorted ascending and -1 requires descending sort.

The end result looks like this.

Hope this helps. Let me know if you bump into any problems with it.

@Emily Reed , if I'm reading your examples correctly, the title of the column Session Title Combo is really Session Title (combo). If this is the case, try changing your MATCH like this:

MATCH([Session Title (combo)]@row

and then see if that helps.