Hello,
I am looking to populate data from Sheet 2 into sheet 1 utilizing mutiple criteria. I tried using index and multiple match criteria's but the formula didn't work. The formula should search for all the data highlighted in yellow from sheet 2 and populate into sheet 1 referencing the line #, salaries or FTE, and dept. no. I prefer not to use the Sumifs formula as that would require me to enter specific formulas for each line # in sheet 1 and highlight the specific line # in sheet 2, correct? Thank you!!
I am looking to populate data from Sheet 2 into sheet 1 utilizing mutiple criteria. I tried using index and multiple match criteria's but the formula didn't work. The formula should search for all the data highlighted in yellow from sheet 2 and populate into sheet 1 referencing the line #, salaries or FTE, and dept. no. I prefer not to use the Sumifs formula as that would require me to enter specific formulas for each line # in sheet 1 and highlight the specific line # in sheet 2, correct? Thank you!!
