Excel formula help
- or -
Post a project like this2155
£10(approx. $13)
- Posted:
- Proposals: 3
- Remote
- #2010985
- Completed
Description
Experience Level: Entry
Need help creating a formula on:
I have a list of vehicle names that have a list of post codes they cover. These codes are only the first 2 characters of a UK postcode.
Basically I want a formula (that's google sheet friendly too) to look at a postcode in a list and assign a vehicle.
Every formula i create doesn't seem to work...
Attached is tables needed to create the formula and my attempt in cell I2
I have a list of vehicle names that have a list of post codes they cover. These codes are only the first 2 characters of a UK postcode.
Basically I want a formula (that's google sheet friendly too) to look at a postcode in a list and assign a vehicle.
Every formula i create doesn't seem to work...
Attached is tables needed to create the formula and my attempt in cell I2
Robert M.
100% (5)Projects Completed
9
Freelancers worked with
7
Projects awarded
53%
Last project
14 Nov 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Robert,
Have you tried using lookup formula?
Regards
642496
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies