hi all - my source data (below) contains numbers, on another sheet i want to basically "lookup" all of the numbers which are greater than 100. hard to explain, so hoping the tables below help.
this is source data
i need a formula that fills the column like this
again i hope that makes sense.
source data sheet - Schedule Import
sheet where i have formulas to return values - Week 1
TIA
this is source data
Handover 2020.xlsx | |||
---|---|---|---|
N | |||
19 | 10 | ||
20 | 840824 | ||
21 | 16 | ||
22 | 840860 | ||
23 | 16 | ||
24 | 840890 | ||
25 | 15 | ||
Schedule Import |
i need a formula that fills the column like this
Handover 2020.xlsx | |||
---|---|---|---|
N | |||
29 | 840824 | ||
30 | 840860 | ||
31 | 840890 | ||
32 | |||
33 | |||
Schedule Import |
again i hope that makes sense.
source data sheet - Schedule Import
sheet where i have formulas to return values - Week 1
TIA