Forum Discussion
VLOOKUP not working with CELL
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.
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.
- Thanks Sergei that works great.
