MANUAL MID HAM AND VLOOKUP
- MID:
MID function is used to return a specific number of characters, so you master.
- Here I choose "VNA234-SGHN" as part of the string
- Also, "1" is the first column
- And "3" is the first 3 digits in the string.
Note: mid function returns only the specific number from left to right.
- This is a formula to function MID
= MID (text; start_num; NUM_CHARS)
- With text is: The string
- Start_num are: Position started to cut strings
- NUM_CHARS are: number of characters to cut out from the string.
2. VLOOKUP:
- Syntactic function: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
- In which: + lookup_value: The value used to detect
+ Table_array: Table value detector, to address as Absolute (with $ sign in front by pressing F4)
+ Col_index_num: The order of the columns in the table to retrieve data values.
+ Range_lookup: The scope of the search, TRUE is equivalent to 1 (detection relative), FALSE is equivalent to 0 (absolute detection).
- VLOOKUP is prospective search function on the column
- Example:
- The function is inserted mid VLOOKUP to find and identify the first three letters in the string
This is the search field on the side panel \
- "2" is the first column in Table 2 parts
- "0" is the absolute detection
