Forum Discussion

timjo-b's avatar
timjo-b
Copper Contributor
Jan 02, 2025

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.

 

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.

 

I tried several formulas but I could not deliver the result required. Many times the formulas displayed the "#SPILL" error. Below is a link to the spreadsheet.

https://docs.google.com/spreadsheets/d/1DEt4jeG8RioHasQ1NCiqkzhI2VLHdDXQ/edit?usp=sharing&ouid=111989026891693955929&rtpof=true&sd=true

 

Any suggestions for a formula or adjustments to the spreadsheet?

 

Many thanks,

Tim

    • timjo-b's avatar
      timjo-b
      Copper Contributor

      Thanks HansVogelaar 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?

      • No, XLOOKUP is only available in Excel in Office 2021, Office 2024 and Microsoft 365.

        The following formula will work in older versions too:

        =IFERROR(VLOOKUP([@[Safety Outline Number]],DC_80_Outlines, 2, FALSE), "")

Resources