LOOKUP a column from another worksheet

U

UTPC01

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 ??
 
U

ufo_pilot

=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 ("")
 
Top