If function with Countif formula

[RAJESH1960]

Hello formula experts

I am trying to get a formula in column E where if column G5 has the name in column C then it should calculate TCS or leave it blank. The number of names in the column G can be null or up to 100 names. I tried using Vlookup with if function but I am not getting it right. In the original data there may be 10,000 rows or more and the TCS Names can be in 1 to 100 rows. I assume a countif with if function will help.

Get TCS to selected Names.xlsx
	A	B	C	D	E	F	G	H	I
1	DATE	INVOICE NO.	Name	Amount	TCS		TCS NAMES		TCS Percentage
2	05-09-2022	1001	Sunday	58500.00	58.50		Sunday		0.001
3	05-09-2022	1002	Monday	70850.00			Wednesday
4	05-09-2022	1003	Tuesday	73045.00
5	05-09-2022	1004	Wednesday	46568.00	46.57
6	05-09-2022	1005	Thursday	12600.00
7	05-09-2022	1006	Friday	14400.00
8	05-09-2022	1007	Saturday	30400.00
9	06-09-2022	1008	Sunday	13750.00	13.75
10	07-09-2022	1009	Monday	61050.00
11	08-09-2022	1010	Tuesday	7936.50
12	09-09-2022	1011	Wednesday	13630.00	13.63
13	10-09-2022	1012	Thursday	25725.00
14	11-09-2022	1013	Friday	35750.00
15	12-09-2022	1014	Saturday	18500.00
16	13-09-2022	1015	Sunday	6600.00	6.60
17	14-09-2022	1016	Monday	3658.00
18	15-09-2022	1017	Tuesday	25080.00
19	16-09-2022	1018	Wednesday	60660.00	60.66
20	17-09-2022	1019	Thursday	21225.00
21	18-09-2022	1020	Friday	18425.00
22	19-09-2022	1021	Saturday	12210.00
23	20-09-2022	1022	Sunday	39600.00	39.60
24	21-09-2022	1023	Monday	15360.00
25	22-09-2022	1024	Tuesday	4096.00
26	23-09-2022	1025	Wednesday	34500.00	34.50
27	24-09-2022	1026	Thursday	24420.00
28	25-09-2022	1027	Friday	17750.00
29	26-09-2022	1028	Saturday	4199.00
30	27-09-2022	1029	Sunday	77120.00	77.12
31	28-09-2022	1030	Monday	51370.00
32	29-09-2022	1031	Tuesday	103490.00
33	30-09-2022	1032	Wednesday	7717.50	7.72
34	01-10-2022	1033	Thursday	40280.00
35	02-10-2022	1034	Friday	3900.00
36	03-10-2022	1035	Saturday	8000.00
PurchaseData

Cell Formulas
Range	Formula
E2,E33,E30,E26,E23,E19,E16,E12,E9,E5	E2	=D2*$I$2

 

[6StringJazzer]

How about

=IF(COUNTIF(G:G,C2)=0,"",D2*$I$2)

 

[RAJESH1960]

Perfect. Thanks Jeff.

 

[6StringJazzer]

You're welcome