This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@DiganP and @euchong1 I would like to get a specific cell e.g buy(1) i.e 66666 if it fulfill the logic.Do note that the table are not fixed which emphasize need to retrieve from a specific cell. Appreciate the help!
= IF(D5='BUY', $F$2, $H$2) => for all rows, one of two specific values is selected depending on the value in a definied column of this row
(counted columns/rows "Excel-like" starting with "No" as A1)
An easy option is to select the values needed (comparable to $F$2 and $G$2), use the "Append Fields" tool to add these values to all rows and use the formula @echuong1 suggested. I've attached a sample workflow.