Hello,
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.
Dawn
