Copper Contributor


I would like to look up index numbers from a column in worksheet A, match it to the same index numbers in worksheet B then find the performance cycle 2018-2019, 2019-2020, 2030-2021 from a column in worksheet B for the associating index # in worksheet B and return the months for exact cycle for that index number: eg

Worksheet A col1: index 123, 321, 213, 421

find in Worksheet B col2:  index 321, 313, 123

then look in worksheet B for performance period for each index # col 3 2018-2019, 2019-2020, 2020-2021 and return the number of months for each performance period  from worksheet B (format is 12 months) so I only want to bring in 12.

Thank you.




1 Reply
Attach a sample file and then show your desired output.