beginner question : V-lookup problem

4.56K viewsFormulas and Functions

Hi ,

I am a beginner to Quantrix.
I’ve read many lookup function like select / using as in the website.
However, when I was trying to do something like excel v-lookup. I have no idea at all :
Matrix 1 with category Colour :
Red 1
Blue 2
Green 3
Yellow 4

Matrix 2 with lookup category:
Blue x
Green x

I type using as / select formula and try to get blue x = 2 and green x = 3; however, both of them do not work.

Anyone could give advice me on this ?


I tried adding one more column copying the name of the category to item. and it works.

Why we need to duplicate the category to items in order to make select / using as function works ?

You are viewing 1 out of 8 answers, click here to view all answers.

Latest Questions