Forum Discussion
Complex autofill formula
I am creating a column of cells (column e) on a data sheet that I want to auto-fill with the contents of a different cell from datasheet named Blad 1 (column A) if the contents in column F fall with...
jalverson Can't help thinking that you are choosing a complicated manner to achieve something that's fairly easy if you create an intermediate table where you link "Åtgärdskoder" with "Komponentkoder". The key seems to lie in the first two digits of the Åtgärdskod. I created such a table in "Blad 1" and referred to it in column E (Plan) with a simple VLOOKUP. You need to check if I mapped the correct Komponent to the correct Åtgärd groups.
Please have a look at the attached file.
Trevlig helg!!
Riny_van_Eekelen This worked great. It is exactly what I was trying to achieve in a complex manner. I haven't used VLOOKUP in about 15 years and forgot about it. Thanks for the help!
