Hello,
My goal is to show the IDs in column C if:
The IDs in Column E, have a corresponding date in Column D that matches Cell C3. My formula does that but I want to add a kind of validation so only the IDs appearing in Column C has a match in Column G.
In my example below, 1234 should not appear in column C because its missing from Column G. Cell C5 should be blank.
Any help is appreciated
Excel 2010Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
My goal is to show the IDs in column C if:
The IDs in Column E, have a corresponding date in Column D that matches Cell C3. My formula does that but I want to add a kind of validation so only the IDs appearing in Column C has a match in Column G.
In my example below, 1234 should not appear in column C because its missing from Column G. Cell C5 should be blank.
Any help is appreciated
| Excel Workbook | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | ||||||||||
| 2 | Date | Date | ID | Approved List | ||||||
| 3 | 12/1/17 | 12/1/17 | 1111 | 333 | ||||||
| 4 | 1 | 1111 | 12/1/17 | 1234 | 2222 | |||||
| 5 | 2 | 1234 | 12/2/17 | 2222 | 1111 | |||||
| 6 | 3 | 333 | 12/1/17 | 333 | ||||||
| 7 | ||||||||||
Sheet1 | ||||||||||
#VALUE!
