I am currently working with 2 excel documents (I have recreated them in simple form below), 'spreadsheet 1' was supplied to me and 'spreadsheet 2' is what I update with my findings.
I would like the length in 'spreadsheet 2' (Column AT) to automatically update with the correct length (from 'spreadsheet 1', 'Column Q') when I input the "Unique ID" into 'spreadsheet 2'.
Also, I would like this length to automatically double in 'spreadsheet 2' if the 'Type' in 'Column F' reads 'Fillet'.
Please note it is not possible to merge the 2 excel spreadsheets!
I have attached the 2 excel documents in question