RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Guys,
I have asked this question before already and I think I got a solution too from this board. But I am not able to search the solution in all the 450 and odd messages. Lately I have started saving the solutions in the bookmark folder. So, I am once again placing somewhat a similar query. As per the image, I have to get the NUMBER in coluumn D in t books column as per portal. If portal, ID and Amounts are same then I must get the NUMBER as per portal to the books row. If as per books, the amount is not blank & if Portal, ID and Amounts are not matching then it should display "Not in Portal". End result, I want the Result in all the cells in column D and none of the cells should be blank.
I have asked this question before already and I think I got a solution too from this board. But I am not able to search the solution in all the 450 and odd messages. Lately I have started saving the solutions in the bookmark folder. So, I am once again placing somewhat a similar query. As per the image, I have to get the NUMBER in coluumn D in t books column as per portal. If portal, ID and Amounts are same then I must get the NUMBER as per portal to the books row. If as per books, the amount is not blank & if Portal, ID and Amounts are not matching then it should display "Not in Portal". End result, I want the Result in all the cells in column D and none of the cells should be blank.
Query to get V No..xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Line | AS PER | ID | RESULT | NUMBER | AMOUNT | ||
2 | 1 | PORTAL | 29ABCD | A1234 | A1234 | 1000 | ||
3 | 7 | BOOKS | 29ABCD | A1234 | 1000 | |||
4 | 13 | PORTAL | 29GHIJ | A1240 | A1240 | 1000 | ||
5 | 2 | PORTAL | 29CDEF | A1235 | A1235 | 2000 | ||
6 | 8 | BOOKS | 29CDEF | A1235 | 2000 | |||
7 | 3 | PORTAL | 29DEFG | A1236 | A1236 | 3000 | ||
8 | 9 | BOOKS | 29DEFG | A1236 | 3000 | |||
9 | 14 | BOOKS | 29DEFG | Not in Portal | 3500 | |||
10 | 4 | PORTAL | 33ABCD | A1237 | A1237 | 4000 | ||
11 | 10 | BOOKS | 33ABCD | A1237 | 4000 | |||
12 | 5 | PORTAL | 33CDEF | A1238 | A1238 | 5000 | ||
13 | 11 | BOOKS | 33CDEF | A1238 | 5000 | |||
14 | 6 | PORTAL | 33DEFG | A1239 | A1239 | 6000 | ||
15 | 12 | BOOKS | 33DEFG | A1239 | 6000 | |||
Sheet1 |