How to retrieve a cell based on a IF logic formula in excel?

[keepcalm]

Hi there,

been trying but to no avail.how do i pick a specific cell from an excel tab if a IF formula logic i used in excel is fulfilled?

E.g if type =buy then get cell from buy(1) else sell (1)

No	id	test account	TYPE	C_P_BUY	buy	C_Y_SELL	sell
1	5268663	123	BUY	KRW	66666	USD	123
2	5268663	234	BUY	KRW	7777	USD	444
3	5268663	555	SELL	USD	8888	KRW	555
4	5268663	666	SELL	USD	9999	KRW	666

Im working all this logic in excel in another tab based on the excel tab above.

Thanks for the help.

[echuong1]

You can achieve this through a formula tool. See attached for an example.

[DiganP]

@keepcalm @echuong1 described the easiest method.

You can learn more about the conditional statements or formula functions in general here. 

[keepcalm]

No	id	test account	TYPE	C_P_BUY	buy	C_Y_SELL	sell
1	5268663	123	BUY	KRW	66666	USD	123
2	5268663	234	BUY	KRW	7777	USD	444
3	5268663	555	SELL	USD	8888	KRW	555
4	5268663	666	SELL	USD	9999	KRW	666

@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!

[RolandSchubert · Accepted solution]

Hi @keepcalm ,

are you trying to replicate an Excel formula like

= 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.

Does this help?

Best,

Roland