If each of the values in A is found to have a match anywhere in the list in D, I should like the values in B and C to be copies out to the right in E and F (against the particular value).
Appreciate your help, thank you.
Example:
Appreciate your help, thank you.
Example:
CA | 77 | no | OH |
FL | 12 | yes | FL |
MA | 7 | yes | NY |
NC | 3 | yes | NH |
NH | 68 | no | CA |
NY | 5 | yes | CA |
OH | 32 | no | NY |
OK | 12 | no | MA |
OH | |||
NY | |||
CA |