beginner question : V-lookup problem

4.56K viewsFormulas and Functions
0

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 ?

0

Thank you for your reply, Jlin.

I was thinking the lookup value in the category area. Please find the attached file.

Thanks !

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

Latest Questions