Question: can vlookup and hlookup be used together?
Answer: VLOOKUP HLOOKUP is a widely used formula combination because of the familiarity of the two formulas. Despite its disadvantages, VLOOKUP is still a more popular formula than INDEX MATCH and understood by a much wider base of users. For that reason, understanding VLOOKUP HLOOKUP is still a worthwhile exercise.