Forum Discussion
JennyHoA20181
May 29, 2025Brass Contributor
Date Lookup based on multiple columns in separate sheet
Hello all, Hoping someone can support! In the 'Date' tab, I want to add another component to the formula in column C. Currently it brings back the first date from Column X of the 'Activity-Risk' Ta...
JennyHoA20181
May 30, 2025Brass Contributor
Thank you Patrick! I get an error that says #SPILL! on my side, could it be my excel version? I am using Xlsb
Patrick2788
May 30, 2025Silver Contributor
The cells below the formula are occupied or you're working in a table is my guess.