How to use Mid function in vlookup

**raghunaik** · 09-09-2009, 05:42 AM

Hi,
Need help in using the Mid function in Vlookup. I want to get the mid of the value which i get using vlookup.

Example: if my Vlookup gives the value as "GSC 03-Parts & Service Systems-GSMS-Test " i want to use the mid function to get the a new value as 03

i'm using the below code but not helping me

Please Login or Register  to view this content.

**DonkeyOte** · 09-09-2009, 05:43 AM

almost, but though you've specified starting point for MID (5) you've specified no. of chars to look at from then on as 0 (final parameter in your formula) and by the looks of it you want to use 2 (ie return 2 chars starting from position 5 in the string).

**aravindhan_31** · 09-09-2009, 08:28 AM

=MID(VLOOKUP(A3,Sheet1!$A$2:$B$6,2,0),5,2)

**raghunaik** · 09-10-2009, 12:13 AM

Thanks for the replies :-)

**isaackoh** · 05-30-2014, 10:47 PM

Originally Posted by aravindhan_31

=MID(VLOOKUP(A3,Sheet1!$A$2:$B$6,2,0),5,2)

hi, how if i want to return the value after the "-"?

**FDibbins** · 05-30-2014, 10:52 PM

isaac...
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.