Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
fkqmz
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
Loading...
Report Reyes • December 4, 2009 11:39 AM GMT
VLOOKUP is your friend (i think)
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
Report Desmond Orchard • December 4, 2009 12:14 PM GMT
Next question, 'How does one spellcheck thread titles?".... ;)
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com