LOOKUP a column from another worksheet
 

Help please i want to show a column from a worksheet based on a TRUE/FALSE
Condition . That is if the value in row2 is TRUE show the column ( im wanting
to show this data on a different worksheet within the same workbook) does
this make sense ??

LOOKUP a column from another worksheet
 

=IF(Sheet2!B1=TRUE,Sheet2!A1,"")

Put this say in sheet1 A1
It reads in cell A1 from sheet2 if the statement "TRUE" is in cell
B1 of sheet2
If B1 reads "FALSE" it will stay blank ("")


"UTPC01" wrote:

Help please i want to show a column from a worksheet based on a TRUE/FALSE
Condition . That is if the value in row2 is TRUE show the column ( im wanting
to show this data on a different worksheet within the same workbook) does
this make sense ??