# Vlookup a value from an array containing the value plus extras

1. ## Vlookup a value from an array containing the value plus extras

Is there a way to VLOOKP a specific value from a group of data that contains that value and some additional information?

Example:
I want to VLOOKUP "ABC" from Column A and return the numerical value that is located in Column B into Column C.

Easy enough Here:

ColA = ABC
ColB = 1122
ColC = ``Please Login or Register  to view this content.``
ColD = ABC

BUT, what if i have the following information instead:

ColA = ABC7458
ColB = 1122
ColC = ??
ColD = ABC

How can i pull the 1122 out of that using the ABC from Column D?  Register To Reply

2. ## Re: Vlookup a value from an array containing the value plus extras

=right(VLOOKUP(A1,A:B,2,FALSE),4)  Register To Reply

3. ## Re: Vlookup a value from an array containing the value plus extras

If you the "ABC" could be anywhere in the data string, or you don't know how long the data string will be, try a formula like the following: ``Please Login or Register  to view this content.``
Let me know if it works.  Register To Reply

4. ## Re: Vlookup a value from an array containing the value plus extras

Thanks for the help!  Register To Reply

5. ## Re: Vlookup a value from an array containing the value plus extras Originally Posted by BigBas If you the "ABC" could be anywhere in the data string, or you don't know how long the data string will be, try a formula like the following: ``Please Login or Register  to view this content.``
Let me know if it works.

I do like this one, but how can i change the "ABC" from your code to the value that is in column D?  Register To Reply

6. ## Re: Vlookup a value from an array containing the value plus extras

If I understand your request correctly, you simply have to change the syntax "ABC" to the cell that contains the value, ie, D1 (note: do not use quotation marks when referencing the cell): ``Please Login or Register  to view this content.``
Let me know if that works  Register To Reply

7. ## Re: Vlookup a value from an array containing the value plus extras

Your correct, it was an error on my part testing it.  Register To Reply

8. ## Re: Vlookup a value from an array containing the value plus extras

I am not sure how to ask this without breaking forum rules...if this should be a new question let me know!

Now, how would i do this?

ColA = ABC7458
ColB = 1122
ColC = ??
ColD = ABC

How can i pull the 7458 out of ColA using the ABC from Column D?  Register To Reply