I have validation lists that pull data from defined names, then I also have a data table that has data on these items. When I drill down with the validation lists, I wanted to populate additional fields with data from this other worksheet. Specifically I wanted to dynamically grab the last two used cells from the data table (slope & intercept).
I am running into trouble trying to get the correct formula to do so:
This does not appear to work and I have been playing around with variations in hope to figure it out with no luck. Slope would be offset -1 from the last used column in the data range, and intercept will be the last used column.
See attached for sample workbook. Thanks in advance.
Bookmarks