To see less ads Register or Login ----- Daily Fantasy Sports games 18+

Vlookup fook up....

A forum for discussion on Science and Information Technology matters and queries (including PCs, the Internet, TVs, Mobile Phones, Ipods and other gadgets).
User avatar
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

Re: Vlookup fook up....

Post by Surprised »

Rob wrote: ↑07 Feb 2020, 21:29
blahblah wrote: ↑07 Feb 2020, 20:20
Rob wrote: ↑07 Feb 2020, 20:11 You could also try index(match()):

=INDEX(Sheet1.$A$1:$F$34,MATCH(B3,Sheet1.$A$1:$A$34,0),1)

Change the 1 to whichever column you want to return.

#N/A


is all I get back, which at least isn't an error 8-)
Does =INDEX(Sheet1.$A$1:$F$34,MATCH(TRIM(B3),Sheet1.$A$1:$A$34,0),1) fare any better?
Must be some spaces at the end of some names in column A or the data isnt totally clean.

User avatar
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

Re: Vlookup fook up....

Post by Surprised »

Did you sort this out blah?

User avatar
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.

Re: Vlookup fook up....

Post by blahblah »

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.....

User avatar
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

Re: Vlookup fook up....

Post by Surprised »

blahblah 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.....
Happens a lot. Just use the Clean or Trim formula

User avatar
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.

Re: Vlookup fook up....

Post by blahblah »

Thanks.

I'll have a look at Clean tomorrow as this is the first of a few I'm going to try... 😨😱

User avatar
Rob
Grumpy Old Man
Posts: 3638
Joined: 24 Jul 2009, 10:54
Location: Poster formerly known as SOBD
FS Record: WC2010 FISODAS Champion!!

Re: Vlookup fook up....

Post by Rob »

Surprised wrote: ↑11 Feb 2020, 19:04
blahblah 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.....
Happens a lot. Just use the Clean or Trim formula
Good advice. Extra spaces happens often with pasted data.

User avatar
murf
FISO Viscount
Posts: 109450
Joined: 13 Oct 2005, 18:28
Location: here
FS Record: Once led TFF. Very briefly.
Contact:

Re: Vlookup fook up....

Post by murf »

blahblah wrote:Ah, I'll work that one out tomorrow as I need chocolate and\or wine now Image
Oh my gawd, I've stumbled onto a mumsnet thread.....

User avatar
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

Re: Vlookup fook up....

Post by Surprised »

murf wrote: ↑11 Feb 2020, 21:28
blahblah wrote:Ah, I'll work that one out tomorrow as I need chocolate and\or wine now Image
Oh my gawd, I've stumbled onto a mumsnet thread.....
Don't pretend you've never had wine and chocolate!

User avatar
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....

Post by forestfan »

I guess he’s purely a beer and crisps man...

User avatar
murf
FISO Viscount
Posts: 109450
Joined: 13 Oct 2005, 18:28
Location: here
FS Record: Once led TFF. Very briefly.
Contact:

Re: Vlookup fook up....

Post by murf »

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.

User avatar
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....

Post by forestfan »

murf wrote: ↑12 Feb 2020, 08:21 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.
That’s an impressive sounding buffet :wink:

User avatar
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

Re: Vlookup fook up....

Post by Surprised »

No Quavers?

User avatar
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.

Re: Vlookup fook up....

Post by blahblah »

Surprised wrote: ↑12 Feb 2020, 13:10 No Quavers?
Ergh no.

User avatar
murf
FISO Viscount
Posts: 109450
Joined: 13 Oct 2005, 18:28
Location: here
FS Record: Once led TFF. Very briefly.
Contact:

Re: Vlookup fook up....

Post by murf »

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.

User avatar
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....

Post by forestfan »

I sense a Crisp World Cup in prospect... maybe one for international break? :wink:

User avatar
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.

Re: Vlookup fook up....

Post by blahblah »

forestfan wrote: ↑12 Feb 2020, 14:54 I sense a Crisp World Cup in prospect... maybe one for international break? :wink:
Didn't we do that?

User avatar
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....

Post by forestfan »

blahblah wrote: ↑12 Feb 2020, 15:16
forestfan wrote: ↑12 Feb 2020, 14:54 I sense a Crisp World Cup in prospect... maybe one for international break? :wink:
Didn't we do that?
Was it less than 4 years ago? :wink:

User avatar
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.

Re: Vlookup fook up....

Post by blahblah »

forestfan wrote: ↑12 Feb 2020, 15:19
blahblah wrote: ↑12 Feb 2020, 15:16
forestfan wrote: ↑12 Feb 2020, 14:54 I sense a Crisp World Cup in prospect... maybe one for international break? :wink:
Didn't we do that?
Was it less than 4 years ago? :wink:
I wouldn;t have thought so :lol:

View Latest: 1 Day View Your posts
Post Reply

Return to β€œScience, Computers & Technology (e.g. PCs, Web, TVs, Mobiles, Ipods, Gadgets)”