Announcement

Collapse
No announcement yet.

Vlookup and Hlookup

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Vlookup and Hlookup



    Could someone explain difference between Vlookup and Hlookup

  • #2


    Yes - VLOOKUP works on a vertical range and HLOOKUP works on a horizontal one.

    =VLOOKUP(A1,$B$2:$C$5,3,0)

    =HLOOKUP(A1,$B$2:$E$3,3,0)

    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    Comment

    Working...
    X