Hi,
I need an excel formula to show a list if cells in column C is blank..
Kindly have a look below. Formula required starting from cell A14
Any help would be appreciated
Regards,
Humayun
I need an excel formula to show a list if cells in column C is blank..
Kindly have a look below. Formula required starting from cell A14
Mr Excel Query.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Sample DATA | ||||
2 | PO # | Target Date | Actual Date | ||
3 | 510 | 1-Jan | |||
4 | 509 | 1-Jan | 5-Jan | ||
5 | 501 | 1-Jan | |||
6 | 825 | 2-Jan | |||
7 | 511 | 5-Jan | |||
8 | 512 | 5-Jan | |||
9 | 498 | 6-Jan | 4-Jan | ||
10 | 123 | 3-Jan | |||
11 | |||||
12 | Pending List | ||||
13 | PO # | Target Date | Actual Date | ||
14 | 510 | 1-Jan | |||
15 | 501 | 1-Jan | |||
16 | 825 | 2-Jan | |||
17 | 511 | 5-Jan | |||
18 | 512 | 5-Jan | |||
19 | 123 | 3-Jan | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B14:B19 | B14 | =VLOOKUP(A14,$A$2:$C$10,2,FALSE) |
Any help would be appreciated
Regards,
Humayun