Hi there,
I am not sure if this is the right forum however I am tasked w/building a cost sheet (I have attached a generic sample file) that will calculate the total cost for a specific test (I named them Test 1, 2, 3, etc.)
I can get most of it done however these tests can have a 'difficulty' which impacts how much time is needed to complete the test and ultimately how much a someone has to pay.
There are 2 difficulties, Avg and High, and I want to have the number of hours switched/flipped depending on whether it is Avg or High, I get it so far as that it works w/Avg but when I select High it won't work, I get an error message.
Any help on how to remedy this would be greatly appreciated or if someone has an alternate way of getting this accomplished I am all ears.
Thank you
I am a novice and don't understand your formula so can not suggest a correction. But I would add the Test column in front of replicate (insert in Column E) and use index/match with two different arrays. Also, I don't know why there is a third match in the formula.
In f4:
=INDEX(Lists!$C$4:$D$18,MATCH($B4,Lists!$B$4:$B$18,0),MATCH($C4,Lists!$C$3:$D$3,0))
and copy down. In G4:
=INDEX(Lists!$E$4:$F$18,MATCH($B4,Lists!$B$4:$B$18,0),MATCH($C4,Lists!$E$3:$F$3,0))
and copy down.
Thank you very much for the answer, and yes, that did the trick
Really appreciated
