D
Dode
Good morning,
I'm trying to use VLookup to populate the second table below using the data
from table 1, but there are two lookup matches that need to occur (Segment &
ReportType) and I am unable to make it work.
TABLE 1 : a1:c9
Segment/ReportType/Hours
AAA/Break/4620
AAA/EmpEng/690
BBB/Break/2435
BBB/Coach/16285
CCC/Coach/50744
CCC/ Empeng/2940
TABLE 2 : e1:I5
Segment/BREAK/COACH/EMPENG
ASC
BBB
BCB
CCC
This is the formula I'm using for one criteria and have tried to alter for
two criterias but without any succes..
=IF(ISERROR(VLOOKUP(K$360,wksheetHRS,2,FALSE)),"0",VLOOKUP(K$360,wksheetHRS,2,FALSE))
Thanks
I'm trying to use VLookup to populate the second table below using the data
from table 1, but there are two lookup matches that need to occur (Segment &
ReportType) and I am unable to make it work.
TABLE 1 : a1:c9
Segment/ReportType/Hours
AAA/Break/4620
AAA/EmpEng/690
BBB/Break/2435
BBB/Coach/16285
CCC/Coach/50744
CCC/ Empeng/2940
TABLE 2 : e1:I5
Segment/BREAK/COACH/EMPENG
ASC
BBB
BCB
CCC
This is the formula I'm using for one criteria and have tried to alter for
two criterias but without any succes..
=IF(ISERROR(VLOOKUP(K$360,wksheetHRS,2,FALSE)),"0",VLOOKUP(K$360,wksheetHRS,2,FALSE))
Thanks