Good Afternoon,
I am trying to replace all of the below TAB1's with a named table, but I cannot figure out the correct format. This formula pulls what I want, but I need it to pull over from multiple tabs, of which I have named the list of tabs as "PM_JO's_for_ drop". The end goal is to return the data in Col U:U from each tab based on the following conditions:
criteria1) 4105, 4106
criteria2) DES Design, GC GENERAL
criteria3) 534320, 534331.
=IFERROR(INDEX(TAB1!$U:$U,MATCH(1,(TAB1!$A:$A=$V$1)*(TAB1!$G:$G=$C34)*(TAB1!$H:$H=$D34),0)),0)
I am trying to replace all of the below TAB1's with a named table, but I cannot figure out the correct format. This formula pulls what I want, but I need it to pull over from multiple tabs, of which I have named the list of tabs as "PM_JO's_for_ drop". The end goal is to return the data in Col U:U from each tab based on the following conditions:
criteria1) 4105, 4106
criteria2) DES Design, GC GENERAL
criteria3) 534320, 534331.
=IFERROR(INDEX(TAB1!$U:$U,MATCH(1,(TAB1!$A:$A=$V$1)*(TAB1!$G:$G=$C34)*(TAB1!$H:$H=$D34),0)),0)
| 4105 | 4106 | 4107 | ||
| DES DESIGN | 534320 | |||
| GC GENERAL CONTRACTORS | 534331 | |||
| 01 GENERAL REQUIREMENTS | 534331 | |||
| 02 EXISTING CONDITIONS | 534331 | |||
| 03 CONCRETE | 534331 |
