Spreadsheet: 676613d1588887068-issues-with-vlookup-with-mid-function-output-mid-vlookup-formula-example
Sheet: Sheet3

 | Unique Code | Desired Formula |  | Desire output for Mid funtion in Column C | Desired Outup for vlookup function in column C |  |  |  |  |  |  |  |  |  | Lookup Value | Lookup Output
 | RB2001-83152 |  |  | 83152 |  |  |  |  |  |  |  |  |  |  | 80301 | Name 1
 | MB2051-83151 |  |  | 83151 |  |  |  |  |  |  |  |  |  |  | 80302 | Name 2
 | MB2011-83152 |  |  | 83152 |  |  |  |  |  |  |  |  |  |  | 80401 | Name 3
 | RB2021-81102 |  |  | 81102 |  |  |  |  |  |  |  |  |  |  | 80402 | Name 4
 | RB1941-80402 |  |  | 80402 |  |  |  |  |  |  |  |  |  |  | 80451 | Name 5
 | RB2001-81702 |  |  | 81702 |  |  |  |  |  |  |  |  |  |  | 80452 | Name 6
 | MB2021-89732 |  |  | 89732 |  |  |  |  |  |  |  |  |  |  | 80501 | Name 7
 | RB2031-89732 |  |  | 89732 |  |  |  |  |  |  |  |  |  |  | 80502 | Name 8
 | RB2001-81802 |  |  | 81802 |  |  |  |  |  |  |  |  |  |  | 80511 | Name 9
 | MB2072-81801 |  |  | 81801 |  |  |  |  |  |  |  |  |  |  | 80512 | Name 10
 | MB2011-80902 |  |  | 80902 |  |  |  |  |  |  |  |  |  |  | 80801 | Name 11
 | RB2001-88602 |  |  | 88602 |  |  |  |  |  |  |  |  |  |  | 80802 | Name 12
 | MB2041-88601 |  |  | 88601 |  |  |  |  |  |  |  |  |  |  | 80811 | Name 13
 | MB2051-88601 |  |  | 88601 |  |  |  |  |  |  |  |  |  |  | 80812 | Name 14
 | MB2031-80912 |  |  | 80912 |  |  |  |  |  |  |  |  |  |  | 80821 | Name 15
 | MB2012-88502 |  |  | 88502 |  |  |  |  |  |  |  |  |  |  | 80822 | Name 16
 | RU1941-88202 JGL Propco |  |  | 88202 |  |  |  |  |  |  |  |  |  |  | 80901 | Name 17
 | MB2031-88202 JGL Propco |  |  | 88202 |  |  |  |  |  |  |  |  |  |  | 80902 | Name 18
 | RB2001-89752 |  |  | 89752 |  |  |  |  |  |  |  |  |  |  | 80911 | Name 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80912 | Name 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80990 | Name 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81101 | Name 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81102 | Name 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81111 | Name 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81112 | Name 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81201 | Name 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81202 | Name 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81251 | Name 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81252 | Name 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81290 | Name 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81301 | Name 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81302 | Name 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81390 | Name 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81401 | Name 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81402 | Name 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81490 | Name 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81501 | Name 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81502 | Name 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81601 | Name 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81602 | Name 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81611 | Name 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81651 | Name 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81652 | Name 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81661 | Name 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81701 | Name 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81702 | Name 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83000 | Name 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83111 | Name 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83112 | Name 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83131 | Name 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83132 | Name 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83151 | Name 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83152 | Name 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83171 | Name 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83172 | Name 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83990 | Name 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88000 | Name 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88232 | Name 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88101 | Name 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88111 | Name 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88121 | Name 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88161 | Name 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88141 | Name 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88202 | Name 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88131 | Name 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88262 | Name 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89001 | Name 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89002 | Name 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89101 | Name 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89102 | Name 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89151 | Name 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89152 | Name 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89201 | Name 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89202 | Name 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89251 | Name 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89252 | Name 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89301 | Name 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89302 | Name 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89351 | Name 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89352 | Name 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89401 | Name 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89402 | Name 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89451 | Name 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89452 | Name 84
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89501 | Name 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89502 | Name 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89551 | Name 87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89552 | Name 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89601 | Name 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89602 | Name 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89651 | Name 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89701 | Name 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89702 | Name 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89711 | Name 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89712 | Name 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89721 | Name 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89722 | Name 97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89731 | Name 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89732 | Name 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89741 | Name 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89742 | Name 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89751 | Name 102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89752 | Name 103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89781 | Name 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89782 | Name 105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89761 | Name 106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89762 | Name 107
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89771 | Name 108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89772 | Name 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88501 | Name 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88502 | Name 111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88601 | Name 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88602 | Name 113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88701 | Name 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88702 | Name 115
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88401 | Name 116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88402 | Name 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81801 | Name 118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81802 | Name 119
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81811 | Name 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81812 | Name 121
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81821 | Name 122
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81822 | Name 123