Hi
I am after a lookup formula that will return Error or Ok in Col E in sheet statement when comparing data between sheet statement and ledger.
Lookup values
pfolio, Quantity, Int rate, Maturity
I am after a lookup formula that will return Error or Ok in Col E in sheet statement when comparing data between sheet statement and ledger.
Lookup values
pfolio, Quantity, Int rate, Maturity
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Pfolio | Quantity | Int Rate | Maturity | ||
2 | ZPTCOM | 1544 | 12.36 | 12/02/2016 | ||
3 | ZH2DD | 5544 | 15.36 | 8/04/2014 | ||
4 | ZH2DD | 5544 | 15.36 | 8/04/2014 | ||
5 | BNHUYR | 115 | 14.2 | 5/04/2015 | ||
6 | GHJYUY | 6548 | 2.8 | 1/06/2015 | ||
Ledger |
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Pfolio | Quantity | Int Rate | Maturity | Check | ||
2 | ZPTCOM | 1,544.00 | 12.36 | 12/02/2016 | OK | ||
3 | ZH2DD | 5,544.00 | 15.36 | 8/04/2014 | OK | ||
4 | ZHERTY | 5,544.00 | 15.36 | 8/04/2014 | ERROR | ||
5 | BNHUYR | 115.00 | 14.2 | 5/04/2015 | OK | ||
6 | GHJYUY | 6,548.00 | 2.8 | 1/06/2015 | OK | ||
Statement |