Forum Discussion
Recherche V
louisecaudal Have look at the attached. Perhaps that does what you want to achieve.
Riny_van_EekelenWhen I select all the column it's not working but if I select only the cells with the information, it's alright. I would like to be able to select the entire column.
Riny_van_EekelenThank you, it's working. Could you explain to me how did you do this ?
Because it's seems the formule is the same as mine.
louisecaudal Not exactly the same. You referenced the entire column A:A in a formula that sits B2. Then Excel will not be able to spill the results as it can not display an entire column starting in row 2. You can put your formula in B1. But then Excel will spill the result to over a million cells in column B. Best to restrict the lookup range to the actual range used. Easily done if you structured tables, as demonstrated in the (revised) file attached.
