Hi,
Likely a simple challenge to some Excel gurus however can't get this coding requirement to work.
I am trying to do a isnumber search from a cell against a named range and outputting the suitably aligned of the values from the named range into the yellow corresponding cell. I have attached an example of the type of action I'm trying to achieve with some simple variances. Any thoughts or questions, please let me know.
Thanks,
James
The fastest way to do this is grab the entire list of COMPANY names and map them all to a Business_Services_Companies so you can do a fast lookup with that new map/table.
I would sort by Company and then just fill in the map manually.
If this is to be used going forward you can always filter on the #N/As to find the missing pieces and then add them to the bottom of your table (then resort).
I have used logic before to find LIKE names but it ended up not being worth the overhead and hassle.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
What you trying to do is what is called a fuzzy lookup. This type of lookup may give you some positive results but not 100% accurate.
Try this formula
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you from London, UK to Florida, US
Thank you again for the help and applying the code, you are correct the accuracy isn't 100% due to its fuzzy parameter.
I have attached an evolution with example of similar but different searches. I have been trying to combine using 'if' statements and 'Len(Substitute)' but again, struggling. Any suggestions?
Thank you for any and all help.
Try this expanded version
Formula: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