VLOOKUP not working with CELL

[Joe Black]

Hello,

I'm having trouble with this project that I'm working on. I'm trying to make a report in which you chose a name from a drop down list and then all of the other information is filled in automaticly. But I'm also trying to make the drop downs auto search when you enter something (like only part of a word) to shorten the list of availible options. I've gotten the auto search to work. But now I'm having trouble with vlookup. It won't read information from my cell("contents"). I'm using cell("contents") to fill all of the rows in the colum to get searchable drop downs.

Any ideas? I'm not locked on this method, so if any of you have a better way of doing this, I can change it.

I attached the example file.

Sheet1 is the "report" and Sheet2 is the "data base". I've colored each function with its own color.

[#2 · Accepted solution]

Hi Joe,

In general it works, but with some limitations. cell("contents") without the reference returns the content of last edited cell. Thus you need double click the cell in sheet 1, start typing any characters, select drop-down list and it shows now the list of words with that characters.

And since you lookup the column in the middle of your sheet 2 array I'd suggest to use INDEX/MATCH in sheet 1, as attached.

[#3]

Thanks Sergei that works great.