MarleneVorster
New Member
- Joined
- Aug 19, 2018
- Messages
- 3
I need to test a postal code in one sheet to a range of codes in another sheet and return the data in a specified cell.
EG: Client's postal code is 0001, test against the Postal Code ranges in col A and return the relevant Province in col B.
<colgroup><col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:8777;width:180pt" width="240"> </colgroup><tbody>
</tbody>
I have tried If And functions without success. Any suggestions please.
EG: Client's postal code is 0001, test against the Postal Code ranges in col A and return the relevant Province in col B.
Postal codes | Province |
0001–0299 | Gauteng |
0300–0499 | North West |
0500–0698 | Limpopo |
0699–0999 | Limpopo |
1000–1399 | Mpumalanga |
1400–1699 | Gauteng |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:8777;width:180pt" width="240"> </colgroup><tbody>
</tbody>
I have tried If And functions without success. Any suggestions please.