Excel VLOOKUP not working - try this

Поделиться
HTML-код
  • Опубликовано: 27 янв 2025

Комментарии • 23

  • @HowToAnalyst
    @HowToAnalyst  3 года назад

    Why was your VLOOKUP not working?

  • @luizakulchetscki2970
    @luizakulchetscki2970 9 месяцев назад +1

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

    • @HowToAnalyst
      @HowToAnalyst  9 месяцев назад

      So glad to help, what are you working on?

    • @luizakulchetscki2970
      @luizakulchetscki2970 9 месяцев назад +1

      @@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.

  • @nidiaveronicagonzalezgurro8969
    @nidiaveronicagonzalezgurro8969 Месяц назад

    Thanks. it was the left to right error for me 🎉❤

  • @mohaiminurarpon2512
    @mohaiminurarpon2512 3 месяца назад

    Thanks man 🖤

  • @carlynicolay1687
    @carlynicolay1687 3 года назад +2

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

  • @kevinschroder3814
    @kevinschroder3814 3 года назад +2

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

  • @anujitmaity0722
    @anujitmaity0722 Год назад +3

    1:50 huge thanks

  • @pratheepanbalendran9889
    @pratheepanbalendran9889 Год назад +1

    It's very useful video

  • @SyedAdnanAbbas-m2z
    @SyedAdnanAbbas-m2z 8 месяцев назад

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

  • @fabricemercier2955
    @fabricemercier2955 Год назад

    Thanks!!!!!!!

  • @nateblack972
    @nateblack972 9 месяцев назад

    TRIM worked 🎉 thanks

  • @thangaveluraj
    @thangaveluraj 2 года назад +1

    Useful but very basic and trivial

    • @HowToAnalyst
      @HowToAnalyst  2 года назад

      Thank you for sharing - what was the problem?

  • @benfithian659
    @benfithian659 3 года назад +1

    Sir, you have great hair

  • @KyleSorenti
    @KyleSorenti 3 года назад +2

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