EXCEL, If column terms match text In range b equal to or less th

Closed
erawkz Posts 2 Registration date Friday June 3, 2016 Status Member Last seen June 5, 2016 - Jun 3, 2016 at 08:00 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jun 6, 2016 at 10:35 AM
Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures I need to associated the id depicted in the middle portion of the attached image.... what I have ... i know im going the wrong way and my job is kinda depending on this... lol HELP! I know ive been going VBA but if a formula would work... I just need this bad.

Buy ya a coffee if you can help me out in anyway.

What Im trying to accomplish



I have a VBA macro buil but IKNOW im going about it wroing...

Sub Find_Matches()
Dim CompareRange As Variant, ToCompare As Variant, x As Variant, y As Variant
Set CompareRange = Worksheets("ID_proptitle").Range("B1:A500")
Set ToCompare = Worksheets("pictures").Range("B1:C500")
For Each x In ToCompare
For Each y In CompareRange
If x = y Then

1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jun 3, 2016 at 09:21 PM
All you need is a simple VLOOKUP.



The VLOOKUP command used here is:
=VLOOKUP(LEFT(A2,LEN(A2)-4),E:F,2,FALSE)


This part ignores the last 4 characters (=001 etc).
LEFT(A2,LEN(A2)-4)


Column F contains a copy of column D as the VLOOKUP command needs to work in that order.

I'll have a Latte. Thanks.
1
erawkz Posts 2 Registration date Friday June 3, 2016 Status Member Last seen June 5, 2016
Jun 5, 2016 at 06:47 PM
A deal is a deal = ), though I ended up using a index and match method... the freakin problem is that the unorganized bunch my clients are... the prop title arent exactly and the post title.. been fidgeting with it the past 40sum hours but im ALMOST done, couple more hours lol... if you have a a paypal; account, pm me withe the email its linked to!! cheers!
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Jun 6, 2016 at 10:35 AM
Glad you are almost there.
Fuzzy matches are always the easiest to do.

Since you have done most of the work, you can have the coffee instead. :)
0