Betfair Community

Home › Chit Chat Forum › i know theres an excel genious somewhere who knows how to do this

Switch to Community Classic App Directory

Chit Chat

Welcome to Live View – Take the tour to learn more

‹ back to topics

There is currently 1 person viewing this thread.

i know theres an excel genious somewhere who knows how to do this

04 Dec 09 11:37

Joined:

Date Joined: 16 May 07

| Topic/replies: 3,313 | Blogger: fkqmz's blog

i need to create a formula which will find text in colomn A then display the data in colomn K from whatever row it finds that text in. Possible?

Pause • Switch to Standard View i know theres an excel genious...

Show More

Reyes

Report Reyes • December 4, 2009 11:39 AM GMT

VLOOKUP is your friend (i think)

Yojimbo

Report Yojimbo • December 4, 2009 11:39 AM GMT

yeah, vlookup

Report fkqmz • December 4, 2009 11:54 AM GMT

ok this is going to work but for some reason its taking the value from the row above, ive ordered the colomn A alphabetically so i cant work out why its returning the wrong value. great shout though cheers for that

Report fkqmz • December 4, 2009 12:09 PM GMT

nailed it, beautiful thank you both very much

Desmond Orchard

Report Desmond Orchard • December 4, 2009 12:14 PM GMT

Next question, 'How does one spellcheck thread titles?".... ;)

Post Your Reply Text Format: Table: Smilies:

Please login to post a reply.

Wonder

Instance ID: 13539

www.betfair.com Betfair