Help with Excel Vlookup Formula - Super Quick Job

Fertiggestellt Veröffentlicht Apr 23, 2014 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

Please take a look at the attached Excel spreadsheet. I'm trying to do a vlookup where column E fills with the values from column I, based on matching column D with column H.

As I've done it, it's returning #N/A for all, even though row 2 is a match.

I'm looking for a revised Excel file with a corrected formula.

I'm trying to get this done ASAP.

Thanks!

Excel

Projekt-ID: #5849855

Über das Projekt

9 Vorschläge Remote Projekt Aktiv Apr 23, 2014

Vergeben an:

vietcompro

Hi there, The problem you have is because in the look-up table, you have a space at the end of the phrase, so that's why VLOOKUP can't look up the value. One way to fix it is to fix the look-up table (delete the spa Mehr

$20 USD in 0 Tagen
(7 Bewertungen)
2.7

9 Freelancer bieten im Durchschnitt $19 für diesen Job

deepbluetech

A proposal has not yet been provided

$10 USD in 1 Tag
(103 Bewertungen)
5.9
ZeusMan

I have this done for you.... Looking forward to working with you...Ready to start as soon as you are....Thank you for the opportunity...

$25 USD in 1 Tag
(70 Bewertungen)
5.9
davidcarroll496

yeah can do it..............................................................................................................................................

$30 USD in 1 Tag
(0 Bewertungen)
0.0
webexpert0000

Ready to start sir, have done similar research projects. Please check my profile for more detail I can provide same asap.. In coloumn E which data u want exactly... Oh, i got the right, just ping me will send u sam Mehr

$15 USD in 0 Tagen
(0 Bewertungen)
1.7
caiogambardela

Hello, Can I try to help you on solving your problem? I'm experienced on excel macros and vlookup as I worked at IBM developing it. Thank You

$25 USD in 3 Tagen
(0 Bewertungen)
0.0
nvlgiang

Hello sir, I just want to help you. Don't need to accept my bid. On the columns I, please remove white space (last character). For ex: change "2nd Site Business Solutions " -> "2nd Site Business Solutions" It a mis Mehr

$10 USD in 0 Tagen
(0 Bewertungen)
0.0
Fikralp

A proposal has not yet been provided

$25 USD in 2 Tagen
(0 Bewertungen)
0.0
prakeoish1

I am really good at VLOOKUP. Hope I got the answer for your question... I have around three plus years of experience in VLOOKUP. I am new to this site. So I have much to do here..

$25 USD in 1 Tag
(0 Bewertungen)
0.0
msilvae27

La propuesta todavía no ha sido proveída

$15 USD in 0 Tagen
(0 Bewertungen)
0.0