Forum Discussion
Solved
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 ...
A variation using XLOOKUP and structured references:
A variation using XLOOKUP and structured references:
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), "")
Thanks HansVogelaar that worked perfect