Question

I need help with two assignments problem1 and problem 2 on index-match

Answer 1

@eashmore

Answer 2

This is tricky because we are asked to match two different values. Additionally, there are duplicates of both schedule and pipe size that will cause the Index and match functions to fail.

However, notice how there is only one combination of each schedule and pipe size. That is, there are not two records in the table for Schedule 40, 2 inch pipe.

We can create a new column in the pipe data table that will be our search "INDEX." This index will combine both the schedule and pipe size for each row in the pipe data table.

For example, Schedule 40, 2 inch pipe will have an INDEX value of "40-2"

We can then search for this unique value to find the requested data. Remember to use the same syntax in the MATCH function. So, if we have selected Schedule 40 and 2 inch pipe in our "Problem 1" sheet, we need to combine these in the same way we did on the pipe data sheet. We will use the CONCATENATE function.

CONCATENATE(<schedule>,"-",<size>)

Answer 3

@thanks again