The best replacement for vlookup is hlookup.

The best alternatives to vlookup are rated as following:
★★★★★  hlookup
★★★★  lookup
★★★  index match
★★★  match
★★  sumif
★  index
★  vlookup
★  if function
★  pivot table
★  find
★  offset
★  hlookup and lookup
★  sumif faster
★  hlookup excel
  match index
  hlookup in excel
  lookup excel
  offset match
  data validation

Your alternative for vlookup is not listed? Suggest!
Speaking about vlookup, one probably shouldn't forget about if statement.

Other search terms related to vlookup and their ratings are:
★★★★★ if statement
★★★★★ sorting
★★★★ if
★★★★ multiple matches
★★★★ duplicates
★★★ match
★★★ na
★★★ sum
★★ exact match
★★ two lookup values
★★ multiple lookup values
★★ #n/a error
★ n a
★ multiple results
★ n a error
★ offset
★ indirect
★ an exact match
multiple columns
wildcard
hlookup
two columns
errors
You have in mind a companion for vlookup and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of vlookup in all years. Click on graph for more.
vlookup
hlookup
lookup