Excel VLOOKUP not working - try this

[@HowToAnalyst]

Why was your VLOOKUP not working?

[@kevinschroder3814]

LEN and TRIM functions - I'll use these for lots of work thanks!

[@HowToAnalyst]

Glad to hear Kevin!

[@carlynicolay1687]

I desperately need this video! I have experienced all of these errors

[@HowToAnalyst]

Hope it’s helpful Carly

[@luizakulchetscki2970]

I can't thank you enough. I was nearly in tears. Thank you!

[@HowToAnalyst]

So glad to help, what are you working on?

[@luizakulchetscki2970]

@@HowToAnalyst I was trying to conduct an Anderson-Darling test on some data as part of my master's thesis. Halfway through my data the #N/A error sign would show up. It was the F4 feature that was missing, to lock in the range.

[@anujitmaity0722]

1:50 huge thanks

[@HowToAnalyst]

You're welcome, glad it helped!

[@nateblack972]

TRIM worked 🎉 thanks

[@HowToAnalyst]

Good to hear

[@pratheepanbalendran9889]

It's very useful video

[@HowToAnalyst]

Glad it helped!

[@fabricemercier2955]

Thanks!!!!!!!

[@benfithian659]

Sir, you have great hair

[@SyedAdnanAbbas-m2z]

on my system while xlookup working properly on his system at same file.
# value error is showing on my system

[@thangaveluraj]

Useful but very basic and trivial

[@HowToAnalyst]

Thank you for sharing - what was the problem?

[@KyleSorenti]

Did you know that the “V” in ‘Vlookup’ stands for “Vertical”? #funfact

[@HowToAnalyst]

Keep em coming Kyle!