Must be some spaces at the end of some names in column A or the data isnt totally clean.
Vlookup fook up....
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Vlookup fook up....
Did you sort this out blah?
- blahblah
- FISO Viscount
- Posts: 108513
- Joined: 13 Oct 2005, 18:46
- Location: .. he thinks that he knows something which he doesn't, whereas I am quite concious of my ignorance.
- FPL:
Re: Vlookup fook up....
Pretty much, this afternoon.
I had copy and pasted from different web pages and probably had some hidden stuff in it... I also realised that all the examples I was using were using Id type things. (Many years ago I sleepwalked to a just about pass in a Database in my MSc )
So typing in shorter id's for the Club name got it working.
I think the c&p'ing kinda explains why I was getting the row above every time due to control type characters hiding.....
I had copy and pasted from different web pages and probably had some hidden stuff in it... I also realised that all the examples I was using were using Id type things. (Many years ago I sleepwalked to a just about pass in a Database in my MSc )
So typing in shorter id's for the Club name got it working.
I think the c&p'ing kinda explains why I was getting the row above every time due to control type characters hiding.....
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Vlookup fook up....
Happens a lot. Just use the Clean or Trim formulablahblah wrote: β11 Feb 2020, 18:57 Pretty much, this afternoon.
I had copy and pasted from different web pages and probably had some hidden stuff in it... I also realised that all the examples I was using were using Id type things. (Many years ago I sleepwalked to a just about pass in a Database in my MSc )
So typing in shorter id's for the Club name got it working.
I think the c&p'ing kinda explains why I was getting the row above every time due to control type characters hiding.....
- blahblah
- FISO Viscount
- Posts: 108513
- Joined: 13 Oct 2005, 18:46
- Location: .. he thinks that he knows something which he doesn't, whereas I am quite concious of my ignorance.
- FPL:
Re: Vlookup fook up....
Thanks.
I'll have a look at Clean tomorrow as this is the first of a few I'm going to try...
I'll have a look at Clean tomorrow as this is the first of a few I'm going to try...
- Rob
- Grumpy Old Man
- Posts: 3638
- Joined: 24 Jul 2009, 10:54
- Location: Poster formerly known as SOBD
- FS Record: WC2010 FISODAS Champion!!
- FPL:
Re: Vlookup fook up....
Good advice. Extra spaces happens often with pasted data.Surprised wrote: β11 Feb 2020, 19:04Happens a lot. Just use the Clean or Trim formulablahblah wrote: β11 Feb 2020, 18:57 Pretty much, this afternoon.
I had copy and pasted from different web pages and probably had some hidden stuff in it... I also realised that all the examples I was using were using Id type things. (Many years ago I sleepwalked to a just about pass in a Database in my MSc )
So typing in shorter id's for the Club name got it working.
I think the c&p'ing kinda explains why I was getting the row above every time due to control type characters hiding.....
- murf
- FISO Viscount
- Posts: 109450
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Vlookup fook up....
Oh my gawd, I've stumbled onto a mumsnet thread.....blahblah wrote:Ah, I'll work that one out tomorrow as I need chocolate and\or wine now
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
- forestfan
- FISO Jedi Knight
- Posts: 36413
- Joined: 13 Oct 2005, 18:27
- Location: Between Westeros and Nova Scotia
- FS Record: FISODAS Champion Season 34!
Re: Vlookup fook up....
I guess heβs purely a beer and crisps man...
- murf
- FISO Viscount
- Posts: 109450
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Vlookup fook up....
I'm purely an Excel man.
Would have solved this hours ago with proper software. Be onto beer, crisps, chocolate, wine, whisky and liquorice catherine wheels by now.
Would have solved this hours ago with proper software. Be onto beer, crisps, chocolate, wine, whisky and liquorice catherine wheels by now.
- forestfan
- FISO Jedi Knight
- Posts: 36413
- Joined: 13 Oct 2005, 18:27
- Location: Between Westeros and Nova Scotia
- FS Record: FISODAS Champion Season 34!
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Vlookup fook up....
No Quavers?
- blahblah
- FISO Viscount
- Posts: 108513
- Joined: 13 Oct 2005, 18:46
- Location: .. he thinks that he knows something which he doesn't, whereas I am quite concious of my ignorance.
- FPL:
- murf
- FISO Viscount
- Posts: 109450
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Vlookup fook up....
The crisps would probably be Doritos or Pringles, maybe Tortilla Pringles.
Could eat Quavers if offered them but not my crisp type snack of choice.
Could eat Quavers if offered them but not my crisp type snack of choice.
- forestfan
- FISO Jedi Knight
- Posts: 36413
- Joined: 13 Oct 2005, 18:27
- Location: Between Westeros and Nova Scotia
- FS Record: FISODAS Champion Season 34!
Re: Vlookup fook up....
I sense a Crisp World Cup in prospect... maybe one for international break?
- blahblah
- FISO Viscount
- Posts: 108513
- Joined: 13 Oct 2005, 18:46
- Location: .. he thinks that he knows something which he doesn't, whereas I am quite concious of my ignorance.
- FPL:
- forestfan
- FISO Jedi Knight
- Posts: 36413
- Joined: 13 Oct 2005, 18:27
- Location: Between Westeros and Nova Scotia
- FS Record: FISODAS Champion Season 34!
- blahblah
- FISO Viscount
- Posts: 108513
- Joined: 13 Oct 2005, 18:46
- Location: .. he thinks that he knows something which he doesn't, whereas I am quite concious of my ignorance.
- FPL:
View Latest: 1 Day View Your posts