Dec 22 2020 02:41 AM
Bonjour,
Sur Office 365 lorsque je fais une recherche V, la formule ne fonctionne pas. L'erreur "EPARS!" apparait. Savez-vous comment résoudre cette erreur? Merci par avance.
Dec 22 2020 02:47 AM
@louisecaudal Have look at the attached. Perhaps that does what you want to achieve.
Dec 23 2020 04:27 AM
@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.
Dec 23 2020 04:49 AM
@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.
Dec 23 2020 07:05 AM - edited Dec 23 2020 07:18 AM
@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.
Apr 07 2024 07:39 AM