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

Report
Posts
2
Registration date
Friday June 3, 2016
Status
Member
Last seen
June 5, 2016
-
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
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 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3984 users have said thank you to us this month

erawkz
Posts
2
Registration date
Friday June 3, 2016
Status
Member
Last seen
June 5, 2016

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!
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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. :)