Index, Match and Indirect COMBO

[abrig005]

Hello, thanks for checking this out.
I am trying to get the percent in a cell from columns L through Q.
The % is dependent on the FY in L1:Q1 and the % is also dependent on the names in column E, R, and G

The names in column E and F are copied to R1 & S1. The FY are contained in L1:Q1. The numbers in column G are auto populated in lets say Z1,Z2 etc.

Note: Sometimes S1 will not have a name and only R1 will be used to lookup the FY and %

Lets say the name 1 BEC (E2) is in R1 and that is the only 1 BEC in the column E, I need to find the % for FY17-FY22 in cells L2:Q2 (98%. 100%, 99%, etc.)
Note: 1 BEC has nothing in column F2 and only occurs once in column E.

However, 1/4 occurs 4x (F4:F7) with different numbers in column G4:G7.
I need the percent for:
1/4 1.4.2 FY17-FY 22
1/4 1.12.7 FY 17- FY 22
1/4 2.2.2 FY 17-FY 22
Etc.
and for row that has a name in just E or both E and F

[/IMG

THANK YOU!!!!!!!!!!!!!!!!!!!!

 

[istiasztalos]

Hi,

When there are multiple rows that match your criteria, which row's % are you looking for?

Also,what would be the output, where would you like to do with the identified % values?