Here' s what I believe will be fairly simple question for some of you, but has me struggling. I would like to take the first three digits of column A and do a lookup of column B that would return the corresponding number from column C. For example, if I entered the formula for 103PH, the lookup would find the 103 in column B and return "2775.00" from column C. Any ideas on the formula to use?
A B C
137MX 102 1081.01
139TH 103 2775.00
103PH (604084) 104 2775.00
402TH (603943) 105 1121.20
124DK 106 19A1.00
383MX 107 1121.20
151PH (604058) 116 2652.00
130PH (604083) 117 2641.00
136PH (604082) 121 265H.01
410CA 123 2641.00
139CA 125 2665.01
121PH (604080) 126 2665.01
165PH (604070) 129 4145.20
402PH (604057) 130 18P5.2
165NZ 131 2110.00
355PH(604081) 132 2110.00
274CA 133 2863.00
402TH (603943) 133 2863.01
Thank you!
Bookmarks