Formula to enter in blank cells - Control G

[RAJESH1960]

Hello guys

I am trying to match portal invoice numbers with tally invoice numbers. I have already separated the portal invoice numbers with a formula and cleared formats of the remaining blank cells in column I. I have to add multiple conditions in a formula by selecting the blank cells.

1. IF E3:H3=FALSE,THEN ENTER I2

2. IF D3= TALLY &E3=FALSE & H3=TRUE, THEN ENTER I1, ELSE ENTER J3.

I am trying to write and enter a formula with the above conditions by selecting the blank cells.

Query to fill matching Invoice Number.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Line	a	b	c	d	e	f	g	CORRECTED	WRONG ENTRIES
2	2345			PORTAL	TRUE	TRUE	TRUE	TRUE	14	14
3	3764			TALLY	FALSE	FALSE	FALSE	FALSE		464
4	1898			PORTAL	TRUE	TRUE	TRUE	TRUE	2758	2758
5	2811			PORTAL	TRUE	TRUE	TRUE	TRUE	3032	3032
6	3179			TALLY	FALSE	TRUE	TRUE	TRUE		2758
7	1186			TALLY	FALSE	FALSE	FALSE	FALSE		3032
8	3129			PORTAL	TRUE	TRUE	TRUE	TRUE	41078/20-21	41078/20-21
9	3843			TALLY	FALSE	FALSE	FALSE	FALSE		41078
10	1639			PORTAL	TRUE	TRUE	TRUE	TRUE	6021/2020-21	6021/2020-21
11	2108			TALLY	FALSE	TRUE	TRUE	FALSE		6021
12	1347			PORTAL	TRUE	TRUE	TRUE	TRUE	6154/2020-21	6154/2020-21
13	1391			PORTAL	TRUE	TRUE	TRUE	TRUE	9304/2020-21	9304/2020-21
14	2288			TALLY	FALSE	TRUE	TRUE	TRUE		6154
15	2354			TALLY	FALSE	TRUE	TRUE	FALSE		2704592
16	3211			PORTAL	TRUE	TRUE	TRUE	FALSE	S-1498	S-1498
17	1655			TALLY	FALSE	TRUE	TRUE	FALSE		Jan-1498
18	3306			TALLY	FALSE	TRUE	TRUE	FALSE		335
2B + TALLY

Cell Formulas
Range	Formula
I2,I16,I12:I13,I10,I8,I4:I5	I2	=IF(D2="PORTAL",J2,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:I18	Cell Value	=TRUE	text	NO

I will be copying the data of column I and paste it back with paste special and also remove the formats from the blank cells. Then I will select the blank cells and apply the right formula if I get the right formula.

 

[RAJESH1960]

I tried these formulas but I am getting a value error in both the formulas.
'=OR(AND(E3:H3="FALSE",AND(D3="TALLY",AND(E3="FALSE",AND(H3="TRUE"),I1,J3))))
=AND(OR(E3:H3="FALSE",OR(D3="TALLY",OR(E3="FALSE",OR(H3="TRUE",I1,J3)))))
Sorry, I forgot to write the 3rd condition which is
3. IF E3=FALSE & H3=FALSE THEN ENTER I2