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 =ColD = ABCPlease Login or Register to view this content.
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?
Bookmarks