New Posts For Thread: i know theres an excel genious somewhere who knows how to do thishttps://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-thisi 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?Next question, 'How does one spellcheck thread titles?".... ;)https://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417504050#417504050Next question, 'How does one spellcheck thread titles?".... ;)Fri, 04 Dec 2009 06:14:07 -0600nailed it, beautiful thank you both very muchhttps://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417504042#417504042nailed it, beautiful thank you both very muchFri, 04 Dec 2009 06:09:07 -0600ok 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 thathttps://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417504002#417504002ok 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 thatFri, 04 Dec 2009 05:54:05 -0600yeah, vlookuphttps://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417503998#417503998yeah, vlookupFri, 04 Dec 2009 05:39:46 -0600VLOOKUP is your friend (i think)https://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417503994#417503994VLOOKUP is your friend (i think)Fri, 04 Dec 2009 05:39:10 -0600i 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?https://community.betfair.com/chit_chat/go/thread/view/94038/23415762/i-know-theres-an-excel-genious-somewhere-who-knows-how-to-do-this?post_id=417503986#417503986i 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?Fri, 04 Dec 2009 05:37:38 -0600