[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
=IFERROR(IF(VLOOKUP($B$1,INDIRECT($E$4&"!"&"$C$4:$GT$43"),COLUMN(BU1)-2,FALSE)="","",CHAR(10)&VLOOKUP($B$4,INDIRECT($E$4&"!"&"$C$4:$GT$43"),COLUMN(BU1)-2,FALSE)),"")
I have this formula already set up cell B33. This formula looks up cells A1 and E1 and will look up alternative tabs in the workbook and return the following info. I do, however, want to include a third condition in B5. I want the formula to take into consideration the three arguments and return the cell references from the alternate tabs.
any help will be greatly appreciated.
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
=IFERROR(IF(VLOOKUP($B$1,INDIRECT($E$4&"!"&"$C$4:$GT$43"),COLUMN(BU1)-2,FALSE)="","",CHAR(10)&VLOOKUP($B$4,INDIRECT($E$4&"!"&"$C$4:$GT$43"),COLUMN(BU1)-2,FALSE)),"")
I have this formula already set up cell B33. This formula looks up cells A1 and E1 and will look up alternative tabs in the workbook and return the following info. I do, however, want to include a third condition in B5. I want the formula to take into consideration the three arguments and return the cell references from the alternate tabs.
any help will be greatly appreciated.