I’m having trouble doing a search in excel.
This is my table:
I have an excel where there are three columns. I would like to look for a certain value in all rows of column1 and if that value exists, get the corresponding value in column3.
So, according to the image of my table, if I look for the value “33” in column1, it should bring me the value “green”.
Remembering that the rows of all columns in this table are not constant, that is, the value 33 can appear in different rows, but it is always in column1.
Can someone help me please?