Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Lookup cell value using list of worksheet names | Excel Worksheet Functions | |||
Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) |