Vlookup and Hlookup

 VLOOKUP stands for 'Vertical Lookup'. It is a function that makes Excel search for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row.

HLOOKUP function , the formula looks for the value of x in the table . It starts from the left corner of the table and looks for the value of x along the top row of the table , the index row .

Easy vartical data pulls in other sheets as per requirment. 

=VLOOKUP (value, table, col_index, [range_lookup])

Using the Order number in column B as a lookup value, VLOOKUP can get the Customer ID, Amount, Name, and State for any order. For example, to get the customer name for order 1004, the formula is

VLOOKUP can only look to the right. The data you want to retrieve (result values) can appear in any column to the right of the lookup values

In most cases, you'll probably want to use VLOOKUP in exact match mode. This makes sense when you have a unique key to use as a lookup value, for example, the movie title in this data

The HLOOKUP function is otherwise known as the “Horizontal lookup function”. It does the same thing as the VLOOKUP function only that the lookup table is arranged horizontally. The HLOOKUP function looks up the value in the first row of the lookup table and returns the corresponding value in a specified table row. HLOOKUP supports approximate and exact matching, and wildcard characters (* ?~) for partial matches.



Comments

Post a Comment

Popular posts from this blog

government policy / training program

  The  National Training Policy  was issued in April 1996 through a set of Operational Guidelines for the development of the human resources of the  Government . ... With the creation of the third tier of  Government , the  training  of functionaries in the Panchayat and Municipal bodies has become a  critical concern. National Training Policy for the Power Sector of India  Considering that the need for training has acquired critical importance in   the context of the rapid technological changes as well as social transformation   taking place in the country in general and power sector in particular, the  Government feels that it is necessary to develop a dynamic training policy in  consonance with the changing business context to achieve higher productivity  and customer satisfaction. Accordingly, a Standing Committee on training was  constituted to bring into focus, the need to step up training and hum...
Read more

प्राइवेट हॉस्पिटल्स इनकम टैक्स किस प्रकार देती है

  GST - गुड्स एंड सर्विसेज टैक्स (जीएसटी) परिषद जल्द ही एक प्रस्ताव पर विचार करेगी, जो अस्पतालों को दवाओं और अस्पताल में भर्ती के लिए अलग से शुल्क देना अनिवार्य बनाता है, एक ऐसा कदम जो स्वास्थ्य सेवा प्रदाताओं से जीएसटी संग्रह में किसी भी रिसाव को प्लग करने में मदद कर सकता है। इस तरह के उपाय से उपभोक्ताओं को लाभ होता है क्योंकि यह अस्पताल के बिलों को अधिक पारदर्शी बना देगा। इस कदम पर एक निर्णय जीएसटी परिषद द्वारा लिया जाएगा, जो पिछले साल लुढ़का हुआ नया कर के लिए सर्वोच्च निर्णय निकाय था। प्रकल्पित कर- जब आप अनुमानात्मक कराधान का विकल्प चुनते हैं। आपकी आय 'अनुमानित है' वास्तविक लाभ की गणना नहीं की जाती है। आप अपने लाभ को अपनी प्राप्तियों का 50% मान सकते हैं। हालांकि, केवल जिनके पास 50 लाख रुपये या उससे कम की वार्षिक रसीद है, वे इस योजना का विकल्प चुन सकते हैं। यदि आपकी वार्षिक रसीद 50 लाख रुपये से अधिक है, तो आपको उन्हें रिपोर्ट करना होगा और लाभ (या हानि) की गणना करने के लिए वास्तविक व्यावसायिक खर्चों में कटौती करनी होगी। यह लाभ 50% प्राप्तियों से कम या अधिक हो सकता है। जो लोग अ...
Read more

Global Logic leaders in software | R&D sevices | Information |सॉफ्टवेयर | में वैश्विक तर्क नेताओं आरएंडडी सेविकाओं | सूचना

Image
About Globale Logic INC He leading specialist in the providing global software product development services, Global Logic Inc. Provides full product development life cycle services to start up, Emerging and established technology companies. 1. Mission & Value: Global Logic’s mission is to partner with the world’s emerging and established software leaders to help them bring great products to market in less time and at less cost. To do this, Global Logic is committed to providing: ·         World-class software engineers who partner with and extend the capabilities of our clients’ existing engineering teams to take on new areas of development ·        Rigorous product engineering method and platform based on distributed Agile software development and open source tools to ensures complete visibility and accountability at each stage during the product development lifecycle ·        Struc...
Read more