Forum Discussion
help with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of e...
addori attached is a sheet with an example of how to do a few things:
a) create data drop downs that auto filter based on partial entries (I.e. type "jo" to filter the dropdown to only show "john", "joseph", "joanne", etc..
b) to use then use a set of fields to return rows of a table that meet those inputs
The data in on 1 sheet and the lookup is on a second sheet with the 'helper' columns used to create the dynamic drop downs over on the right around columns M,N,O, etc... (you could hide these)
Hey mtarler. Thank you for the reply (sorry It took me a while to get back).
I tried to use your file as a sample, but one I open it and try to use the method you offered I get an error (invalid). So I know for fact I'm doing something wrong.
Also, I'm using two sheets in the same workbook. So in one there's my data and the other I use it as an "index".
I tried to use your file as a sample, but one I open it and try to use the method you offered I get an error (invalid). So I know for fact I'm doing something wrong.
Also, I'm using two sheets in the same workbook. So in one there's my data and the other I use it as an "index".
- what version of Excel are you using? In particular are you using Excel 365? The workbook I sent uses FILTER() function which is only available in Excel 365.
If you ARE using Excel 365 then please explain more what isn't working or what you see when you open my sample.