Simple Vlookup - Not Working
- or -
Post a project like this2101
£10(approx. $13)
- Posted:
- Proposals: 16
- Remote
- #2062270
- Awarded
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Virtual Assistant / Excel Spreadsheets / Fillable PDF form / Bookkeeping / PDF to Excel / word conversion / Transcription / Data mining / Web scarping
Hyderabad
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Chartered Certified Accountant (ACCA) / IFRS and reporting specialist / Excel expert / Xero Advisor / Book keeper
Yanbu` al Bahr
96180036844748649574541113650061394015153654717509011788290213850622076872244457
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have very little knowledge of excel and have attempted a VLookup, but am not getting the results i expected
I need to compare the barcodes in column D with the barcodes in column A and any matches need to return the value in column B under the results column (E)
I think this is to do with the formatting of the data, but i cant work out the error.
I know 100% some of these barcodes should match but the results i am getting are #N/A
I want the formula for the Vlookup to be editable so i can use this file in the future for other V Lookups.
Thanks
I need to compare the barcodes in column D with the barcodes in column A and any matches need to return the value in column B under the results column (E)
I think this is to do with the formatting of the data, but i cant work out the error.
I know 100% some of these barcodes should match but the results i am getting are #N/A
I want the formula for the Vlookup to be editable so i can use this file in the future for other V Lookups.
Thanks
Steve J.
100% (50)Projects Completed
57
Freelancers worked with
47
Projects awarded
84%
Last project
27 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Steve,
It would help immensely if you posted a screenshot of the dataset. -
Steve,
can you please share the file, or its extract..
668278668241
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