Hi there,
I have a number of template/master sizes (of poster ads, as it happens) and a whole range of actual poster sizes I need to adapt to from one of these template/master sizes. I have worked out the aspect ratio of each template/master, and the aspect ratio of each size required. What I want to do is insert a formula so that for each size I have to create it tells me which is the closest template/master match. If there are two template/masters that are an identical distance away I would like to use the template/master that has the lower aspect ratio. I have attached a simple spreadsheet which has a simplified example of what I am looking to do. It has a range of Template (Master) Names with the aspect ratio of each template/master in the row underneath. I also have two columns of poster sizes required, with a third column that calculates the aspect ration for each size required. I have a fourth column which is where I want the Template/Master name to appear as a result of the formula. For now I have manually entered the correct result - because I don;t know how to write the formula. I have played around with Match and Index and Lookup for ages but just cannot get it to do what I want. All and any hep gratefully appreciated.
I have a number of template/master sizes (of poster ads, as it happens) and a whole range of actual poster sizes I need to adapt to from one of these template/master sizes. I have worked out the aspect ratio of each template/master, and the aspect ratio of each size required. What I want to do is insert a formula so that for each size I have to create it tells me which is the closest template/master match. If there are two template/masters that are an identical distance away I would like to use the template/master that has the lower aspect ratio. I have attached a simple spreadsheet which has a simplified example of what I am looking to do. It has a range of Template (Master) Names with the aspect ratio of each template/master in the row underneath. I also have two columns of poster sizes required, with a third column that calculates the aspect ration for each size required. I have a fourth column which is where I want the Template/Master name to appear as a result of the formula. For now I have manually entered the correct result - because I don;t know how to write the formula. I have played around with Match and Index and Lookup for ages but just cannot get it to do what I want. All and any hep gratefully appreciated.