Question

Explain LOOKUP, VLOOKUP and HLOOKUP with examples.

08 Oct 2024
Answer :
Word Count : 243

LOOKUP, VLOOKUP, and HLOOKUP are functions in Excel that are used to search for specific data within a dataset and return corresponding values.

LOOKUP is a versatile function that searches for a value in a one-row or one-column range and returns a value from the same position in a different range. It can be used for both vertical and horizontal lookups. For example, if you have a list of product names in column A and

_____ _______ ____ _____ ____ ___ _____ _____ ______.
___ ____ ______ ______ __________.
________ _______ ___ _______ _________ _________ ___ __________ _________ ___.
_______ _______ ______ ____ _______.
_________ _________ _____ _______ _____ _____ ________ ___.
__________ ___ ____ ___ ________ _______ __________ ____ _______ ______ _________ __________.
__________ _________ _____ _________ ____ ____ ________.
___ _________ ________ _______ ______ ______ ________ __________ ___.
___ ____ _________ ______ ________ _________ _______ _______ _____ __________ ______.
________ ________ ____ ______ ____ _______ _____ _____ __________ ________.
______ _______ _____ _____ __________ _________ ________ __________ _________.
____ _____ ____ _________ ______ ___.
_______ __________ _____ __________ ________ ________ __________ _________ _____ __________ ________ _______.
____ ______ ____ _______ ________ _____ ____ ____.
_________ ___ ___ ______ ________ _____.
_______ ___ ___ _______ _________ _______ _______ ____ ____.
_________ ____ ____ ________ __________ __________ ___ ______.
_______ ________ _____ _________ _____ ___ _________ ________.
____ ________ _____ _______ _______ __________ ________.
________ ________ _________ _____ _____ _______ _______ ___ ________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU BCOS 183 2024 2025 - Explain LOOKUP, VLOOKUP and HLOOKUP with examples. | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→