Search results

Thanks! I think I'll put out to tender on Upworld.com tomorrow first thing. It's something could have done with years ago really, in house IT teams used to assist with 'fuzzy logic' but no one really managed to solve so thought I'd ask a wider community for help. NSC has solved a lot more...

See 38 for the actual raw data (assuming you're able to help still) - have to say, this is a bit of a bugger. Fuzzy logic and some!

Hi, I've tried but error message keeps coming back. Developer and Macros is an area I'm really not familiar with though (and it's slightly different set up on a Mac). I read this only after my post 38 mind.

Hi and thank you, what a bit of code you've written!! Good news - it worked correctly! But only up to a point, so I'll come clean and present the real data so you can see exactly what I'm talking about (I tried to make it 'footy like' but probably best I just show the RAW data. Sheet 1...

Thank you so much! Sorry to put you (all) to so much trouble. It's very much appreciated.

Thanks - but how would you apply this to resolve my issue (see post 28)

And thanking you for assisting to! :)

Hi Buzzer, see my post 28 - so sorry, I just couldn't get that to work given the data is on a 2nd sheet. I've laid out as per my actual s/s, are you able to assist still please?

Not quite - still struggling :( Are you still able to assist, see my post 28

Buzzer MartinTyler clapham_gull Hi again, very grateful for all the support so far but applying the above to my actual data isn't working because I'm on different sheets. I've been banging head against wall a lot this morning!! So decided to present screenshots of exactly how it's laid out so...

You Sir, are a genius! Thank you Lord Buzzer, I now need to replace the "A"&ROW(... bit with my table array on another s/s, so it's looking at that value instead. But I think I can do that and hopefully it'll compare the two workbooks and returning said value correctly.

Believe me, I would if it was feasible. There are many variations on thousands of names. And everyone uses different variations so we've built a table array to look up against and see if company 'x' is exists in it already, regardless of how someone might spell it (former name, with or without...

Ah, sorry, the table array is in another worksheet so that won't work.

Giving it a go now. Thanks. Will let you know accordingly :)

Probably, but I've not got those skills and the industry I'm working with is extremely s/sheet based so it's the currency I must use so's to speak.

See below and thanks for trying to help. Yes, it was a bit of a mess trying to explain without a screenshot. Now provided.

Thanks King Kev, it's a bit more tricky than a standard vlookup because I'm searching to find a match across several columns first, rather than just one static column; and then I want it to return the associated value (92pts) if it does find a match to one of the spellings. But for your...

A beer coming your way at the Wigan game if so!! I'm definitely stuck - and I'm the Excel 'guru' in my business! ;)

Hi, here's a screenshot to explain better (sorry folks!). So you can see what I'm searching for: the names in column G. Having found them - because they're are multiple ways of spelling these 2 teams, shown in columns B to E - in the adjacent 'table array' (using the formula shown in the...

I'd be eternally grateful if anyone wants to assist, it's to do with finding name variations within a table array and if found, returns a value from another column within that table array. Table Array has these variations on a name by column e.g. (A = 92pts) B =Brighton C=Brighton&HA...