अगर आप Microsoft Excel चलाते है या फिर इक्सेल को चलना सीख रहे है ये पोस्ट आपके लिए ही है, क्योंकि मे आपके लिए कुछ MS Excel Lookup and Reference Functions हिन्दी मे ले कर आया हु, जोकी आपको बहुत काम आने वाले है।
Excel Lookup and Reference Function in Hindi
| Function | Description |
|---|---|
| ADDRESS function | Returns a reference as text to a single cell in a worksheet |
| AREAS function | Returns the number of areas in a reference |
| CHOOSE function | Chooses a value from a list of values |
CHOOSECOLS..function | Returns the specified columns from an array |
| CHOOSEROWS function | Returns the specified rows from an array |
| COLUMN function | Returns the column number of a reference |
| COLUMNS function | Returns the number of columns in a reference |
| DROP function | Excludes a specified number of rows or columns from the start or end of an array |
| EXPAND function | Expands or pads an array to specified row and column dimensions |
| FILTER function | Filters a range of data based on criteria you define |
FORMULATEXT function | Returns the formula at the given reference as text |
GETPIVOTDATA function | Returns data stored in a PivotTable report |
| HLOOKUP function | Looks in the top row of an array and returns the value of the indicated cell |
| HSTACK function | Appends arrays horizontally and in sequence to return a larger array |
| HYPERLINK function | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
| INDEX function | Uses an index to choose a value from a reference or array |
| INDIRECT function | Returns a reference indicated by a text value |
| LOOKUP function | Looks up values in a vector or array |
| MATCH function | Looks up values in a reference or array |
| OFFSET function | Returns a reference offset from a given reference |
| ROW function | Returns the row number of a reference |
| ROWS function | Returns the number of rows in a reference |
| RTD function | Retrieves real-time data from a program that supports COM automation |
| SORT function | Sorts the contents of a range or array |
| SORTBY function | Sorts the contents of a range or array based on the values in a corresponding range or array |
| TAKE function | Returns a specified number of contiguous rows or columns from the start or end of an array |
| TOCOL function | Returns the array in a single column |
| TOROW function | Returns the array in a single row |
| TRANSPOSE function | Returns the transpose of an array |
| UNIQUE function | Returns a list of unique values in a list or range |
| VSTACK function | Appends arrays vertically and in sequence to return a larger array |
| VLOOKUP function | Looks in the first column of an array and moves across the row to return the value of a cell |
| WRAPCOLS function | Wraps the provided row or column of values by columns after a specified number of elements |
| WRAPROWS function | Wraps the provided row or column of values by rows after a specified number of elements |
| XLOOKUP function | Searches a range or an array and returns an item corresponding to the first match it finds. If a match doesn’t exist, then XLOOKUP can return the closest (approximate) match. |
| XMATCH function | Returns the relative position of an item in an array or range of cells. |
Source: Mircosoft
MS Excel Lookup and Reference Functions PDF Download
MS Excel Lookup and Reference Function की PDF को डाउनलोड करना चाहते है तो हमारे Telegram Group से जुड़ कर आसानी से Excel Pdf को अपने मोबाईल computer मे डाउनलोड कर सकते है।
हमने यहा पर लगभग सभी MS Excel के Lookup and Reference के Functions को हिन्दी मे इस लिस्ट मे समिल किया है, अगर आपके पास कोई Function है जोकी इस लिस्ट मे समिल हो सके तो हमे Comment मे बताए।
- MS Excel Logical Functions PDF List Download
- MS Excel Compatibility Functions List PDF Download
- MS Excel Engineering Functions List PDF Download
- MS Excel Statistical Functions List PDF Download
- MS Excel Text Functions List PDF Download
- MS Excel Financial Functions List PDF Download
- MS Excel Database Functions in Hindi
- MS Excel Date and Time Functions
- MS Excel Web Functions PDF Download
- MS Excel Lookup and Reference Functions List PDF Download
- MS Excel Math and Trigonometry Functions List PDF Download