A1 | B1 | C1 | D1 | E1 |
<tbody>
</tbody>
=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.