compare a value in one column and then use the number in another column on the same row

Question

Hello I am trying to figure what formula I can use when a value in one column matches a word in one column and use a number in the same row but a different column and then multiply that number by a number in a different cell. See table and description below:

	A	B	C	D
1	TRUE/FALSE	PERCENT
2	FALSE	.30	3456	1209.6
3	TRUE	.35
4	FALSE	.40
5	FALSE	.45

More detail - Trying to populate cell D2 by using a formula from a multiple of variables. Column A is populated from other data. TRUE could be in any of the 4 rows (2-5). Depending in which row in column A matches TRUE. Then use the number in that same row from column B. Example A3 = TRUE so use value in B3 = .35. Then multiply that number (.35) times the number in C2 and populate it in D2.

Example if A2 = TRUE use .30 (B2) * 3456 (C2) = 1036.8 (D2)

Example if A4 = TRUE use .40 (B4) * 3456 (C2) = 1382.4 (D2)

Example if A5 = TRUE use .45 (B5) * 3456 (C2) = 1555.2 (D2)

Answer 1

Hello,

Have you tried this in D2? =C2*XLOOKUP(TRUE, $A$2:$A$5, $B$2:$B$5)

You can then adjust your data range to reflect the true data range. I did put the anchors to lock the range so when you drag, the data range won't change.