paul29berks
Active Member
- Joined
- Mar 15, 2004
- Messages
- 293
I wondered if someone could help. I have forgotten the formula to look up values.
Basically I have 1 column that contains Codes (Shown as column 2 below)and I need to verify that these codes are valid against another column (Column 1 below) by doing a simply lookup. I wish to return the value True or false dependant on whether the code exists or not.
Can someone else.
Thanks
Paul
For example
Column 1 (valid codes) Column 2 Codes to check)
12345 11
1234 5
123 124
12
1
11
124
Basically I have 1 column that contains Codes (Shown as column 2 below)and I need to verify that these codes are valid against another column (Column 1 below) by doing a simply lookup. I wish to return the value True or false dependant on whether the code exists or not.
Can someone else.
Thanks
Paul
For example
Column 1 (valid codes) Column 2 Codes to check)
12345 11
1234 5
123 124
12
1
11
124