Forum Discussion
lauraeileen
Mar 14, 2023Copper Contributor
Fill cell values based on cells provided
Hi there, I am searching for a function that can assist with the following: I have a list of animals, for example, 50 animals at a certain location - with species name only. I have a database...
Riny_van_Eekelen
Mar 14, 2023Platinum Contributor
lauraeileen Depending on the Excel version you work with, that could be done by using either of the following functions: VLOOKUP, INDEX combined with MATCH, XLOOKUP or FILTER.