Chit Chat
There is currently 1 person viewing this thread.
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?
sort by:
Show
per page
Replies: 5
|
By:
VLOOKUP is your friend (i think)
|
|
By:
yeah, vlookup
|
|
By:
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
|
|
By:
nailed it, beautiful thank you both very much
|
|
By:
Next question, 'How does one spellcheck thread titles?".... ;)
|