Lookup Function

[#1]

Hi,

Now that the Lookup() function is gone, how do I do an easy lookup?

Unique ID	ColA	ColB	ColC
1	xxx	yyy	zzz
2	rrr	sss	ttt
3	uuu	vvv	www

Say I have id=2 and col='ColC'. How do I get to 'ttt' now without creating millions of mapping tables?

Thanks!

[anbu1984]

Try this

If(id=2,pick(match(col,'ColA','ColB','ColC'),ColA,ColB,ColC))

[rbecher]

Hi (number),

why not just using QlikView's Lookup() function?

- Ralf

[#4]

Because I don't think Lookup exists anymore in my version?

Thanks!
Oli

[#5]

That's just hardcoding it... What if id=24343 and col=ColXY?

[rbecher]

Why? Which version?

[#7]

As far as I know the lookup function still exists?

[#8]

QV11... Doesn't come up!

Thanks

Oli

[#9]

See above...

[#10]

That's actually really strange, I can see it in my help menu but I see the same problem you do...