I need to perform a vlookup where only part of the match in the Table Array will match the Lookup Value. The matches will always be from the left hand side. I was thinking of a vlookup(left(len type formula so that it only searches the same amount of characters as contained in the Lookup Value but I can't get it to work. See the attached example if I am not describing the problem well enough. Thanks in advance!
You can use wildcards in the VLOOKUP if you use an exact match
in this instance you could also usee SUMIF rather than VLOOKUP
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Maybe:
=VLOOKUP(A2&"*",'Table Array'!$A$2:$B$12,2,0)
Great minds think alike! Thanks guys. Not sure why I didn't think of wildcards.
The sumif scenario sounds interesting too, I would love to hear how that would work.
Exactly the same concept except that SUMIF will aggregate values if more than one instance exists at source:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks