Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Vlookup by containing same word

Hi.

I have two data from different sources and want to add new segment colunm(in data 1) next to where are the model names are combined. one table(data2) has all the individual model name and its segments.

 

I want to use something like V lookup in excel and create a segment colunm for data1 as long as it contains at least one same model in the combined models.

 

Data1. I want to create a segment colunm in this table by search the matching model name from Data 2Data 2.Hope it make sense!

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous

    If one models contains many model, the segment will have more than one value.

    so you need to create a new table as below:

    this is simple data

    data1data2

    Then use this formula to create a new table by SEARCH Function

    Table = FILTER(GENERATE(data1,data2),SEARCH(data2[Model],data1[Modes],1,0)>0)

     

    Best Regards,

    Lin

     

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    HI, Anonymous

    If one models contains many model, the segment will have more than one value.

    so you need to create a new table as below:

    this is simple data

    data1data2

    Then use this formula to create a new table by SEARCH Function

    Table = FILTER(GENERATE(data1,data2),SEARCH(data2[Model],data1[Modes],1,0)>0)

     

    Best Regards,

    Lin