Forum Discussion
timjo-b
Jan 02, 2025Copper Contributor
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
A variation using XLOOKUP and structured references:
A variation using XLOOKUP and structured references:
- timjo-bCopper 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), "")