Forum Discussion
Lucy_Stevens
May 14, 2024Copper Contributor
Auto fill data in adjacent cells
Hello, I am trying to automate filling in of data in a column based on the data in the adjacent column. Specifically, I have two columns in a sheet relating to Habitat code (column A [I.e g3c]) and...
Martin_Angosto
May 14, 2024Iron Contributor
Please see attached document with proposed solution. On sheet2 you will find the formulation with an INDEX/MATCH formulation.
Martin