
LookUp('Interview Questions', 'Inquiry Question' = "Initial Scoping Interview Date" And 'Inquiry Category' = "General").'Inquiry Answer'
Adjust the column names if needed.
If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!