help me out for a sec please

[Testin da Cable]

I'm stuck on a bit of excel. I hate excel. I would happily beat excel to death with a large hammer.

I've been looking up values like so: MATCH(D6;J:J;0)

cell d6 is a number, J:J is the array to search, 0 is the match type
the returned value is a row number, in this case 60. what I actually want is the contents of I60. I've tried and tried all kinds of shit but I've only managed to get "I60" returned as a text value. I don't want a frigging text value, I want cell I60.

Help. Please help.

 

[~YuckFou~]

good luck.

Excel is the work of Satan.

 

[Testin da Cable]

GOT IT GOT IT!!!


VLOOKUP(D6;J5:K102;2;FALSE)


I had the array back to front. I had been thinking "oh god it's prolly been sorted wrong. Ah well. What a bastard

 

[dysfunction]

If you leave the FALSE out it selects the very next record it finds...if the item is not in the lookup list...

 

[Testin da Cable]

no, I need the FALSE to get an exact match

 

[Scooba Da Bass]

Originally posted by Testin da Cable
VLOOKUP(D6;J5:K102;2;FALSE)

*shudders at A level flash backs*

 

[~Lazarus~]

Originally posted by Testin da Cable


no, I need the FALSE to get an exact match

Remember that the input array needs to be sorted too.

 

[granny]

You might be able to do it if you reconfigure the emitter array to generate a burst of polarised tachyons.

 

[MYstIC G]

Originally posted by Scooba Da Bass


*shudders at A level flash backs*

*laughs cos vlookup was beginner GCSE when I did it*

 

[~YuckFou~]

Originally posted by MYstIC G
*laughs cos vlookup was beginner GCSE when I did it*

Laughs even more 'cus PC's had only just been invented when at school.

 

[bulb0r]

all the formulae does my head in

ADD(j5swkj3o5jsdfhk34jh5kjhfhj34) = 1

:/ shouldve never exsisted

whats wrong with normal sums stupid billy the willy gat0r

 

[Testin da Cable]

Originally posted by ~Lazarus~


Remember that the input array needs to be sorted too.

yeah yeah that part I had down. thing I don't really get is that it doesn't have to be sorted sometimes. I'd say sort it all the time so you don't run into trouble later

 

[.Cask]

Originally posted by granny
You might be able to do it if you reconfigure the emitter array to generate a burst of polarised tachyons.

That would cause a feedback loop in the phase couplinks.

The solution is obviously to reconfigure the holomatrix to accept ionised warp plasma, thereby creating a phsyical duplication of the array in the form of 20th century characters with which several members of the senior staff can interact with.

 

[danger]

Originally posted by .Cask


That would cause a feedback loop in the phase couplinks.

The solution is obviously to reconfigure the holomatrix to accept ionised warp plasma, thereby creating a phsyical duplication of the array in the form of 20th century characters with which several members of the senior staff can interact with.

Now that's just silly.

Everyone knows you need to take the inertial dampers offline while you reconfigure the isolinear chips of the warp core manually allowing an anti-matter surge to be emitted through the deflector array, creating a temporal rift through which you can travel back in time and prevent excell from ever being invented!