Hi All,
i have a spreadsheet with 3 sheets inside, sheet 1 is a full list of parts but its missing details in the last column (Zoll). Sheet 2 has the details required in the (Zoll) column but it isn't a full list. Sheet 3 is where i would like to have it look at the details in column (Benunnung) from sheet 2 and if the item matches then it would take the details from the Zoll column and fill in the details in sheet 3. Anywhere there isn't an item in sheet 2 that is in sheet 3 it would then leave the cell blank. I have attached 3 images just for reference (they are just partial screenshots but it shows the idea. i have coloured the column where the details is missing or where it comes from. the data is sheet 1 and 3 will always be the same but sheet 2 could have defferent amounts of items.
I hope this makes sense to someone?
TIA
Kev
i have a spreadsheet with 3 sheets inside, sheet 1 is a full list of parts but its missing details in the last column (Zoll). Sheet 2 has the details required in the (Zoll) column but it isn't a full list. Sheet 3 is where i would like to have it look at the details in column (Benunnung) from sheet 2 and if the item matches then it would take the details from the Zoll column and fill in the details in sheet 3. Anywhere there isn't an item in sheet 2 that is in sheet 3 it would then leave the cell blank. I have attached 3 images just for reference (they are just partial screenshots but it shows the idea. i have coloured the column where the details is missing or where it comes from. the data is sheet 1 and 3 will always be the same but sheet 2 could have defferent amounts of items.
I hope this makes sense to someone?
TIA
Kev