Fill a table cell with data from another table based on the adjacent table cell value

Hi Community members,

I am compiling a spreadsheet to list the department meeting schedule for the year, retain records of past meetings, and record statistics for meeting presenters.

Sheet "DC-80 Outlines" contains a table listing talk outlines prepared by my company's WHS department. Several other sheets will reference this sheet. A screenshot is attached.

In the sheet "Schedule Archive", I used a named range for the data validation list in column C. That named range is column A in the "DC-80 Outlines" sheet. I want to insert a formula in column B that fills the talk outline title from the "DC-80 Outlines" sheet based on the value selected from the data validation list in column C. A screenshot is attached.

I tried several formulas but I could not deliver the result required. Many times the formulas displayed the "#SPILL" error. The spreadsheet is attached.

Any suggestions for a formula or adjustments to the spreadsheet?


Many thanks,
Tim

This, maybe:

Formula:

=XLOOKUP([@[Safety Outline Number]],DC_80_Outlines[Number],DC_80_Outlines[Title],"")

Thanks TMS for your help, that formula worked. I had used that formula previously but no results were displayed because the cell format was set to TEXT instead of GENERAL 🤦

Some users will be accessing this spreadsheet using Excel 2019. Is XLOOKUP compatible with Excel 2019?

Is XLOOKUP compatible with Excel 2019?

Sadly, no. We will need to use VLOOKUP or INDEX/MATCH instead. And also use IFERROR to cope with missing entries.

Formula:

=IFERROR(INDEX(DC_80_Outlines[Title],MATCH([@[Safety Outline Number]],DC_80_Outlines[Number],0)),"")

Why have you got 200+ blank rows in your Table?

Thanks for the rep