RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
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.
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.
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.
Last edited: