Iain A
New Member
Any help would be appreciated with the attached file. I am trying to use combined VLOOKUP with HLOOKUP or INDEX MATCH Formulas but my inferior excel knowledge has got me nowhere
What I have is a Range of Data that has lists of Components, each component has several columns of data (BOE) and each component has a Minimum, Most Likely and Maximum value.
I have a Summary sheet that has 3 dropdown boxes where I select Components, then the column headers (BOE) then select either Minimum, Most Likely or Max and an Answers box where I want the value returned.
What I have is a Range of Data that has lists of Components, each component has several columns of data (BOE) and each component has a Minimum, Most Likely and Maximum value.
I have a Summary sheet that has 3 dropdown boxes where I select Components, then the column headers (BOE) then select either Minimum, Most Likely or Max and an Answers box where I want the value returned.