Forum Discussion

GRikerWillig's avatar
GRikerWillig
Regular Visitor
5 years ago
Solved

Vlookup for Text between multiple data sets

Hi All, I'm sure I'm missing something incredibly obvious, but I'm struggling to perform a VLOOKUP type function between a 2 sets of data. The first is a live pull from our CRM system that I need to...
Need Help
  • GRikerWillig's avatar
    GRikerWillig
    5 years ago

    I checked to confirm that all of the values I'm pulling are text. This is the error that I keep getting:

    Not sure how to get around this one...

     

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi GRikerWillig 

Is this what you want?

 

  • GRikerWillig's avatar
    GRikerWillig
    Regular Visitor
    5 years ago

    Looks like I was creating a measure instead of a column which was the cause of my difficulties. Thank you so much for your patience and help!

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      I thought so, But you made it.

       

      Welcome

  • GRikerWillig's avatar
    GRikerWillig
    Regular Visitor
    5 years ago

    It definitely would be if I could get it to work 😞 I have already confirmed that there IS a relationship created between the tables, I started there first, but when I started typing in the related function, no Table/Column combos populated so is it possible that I entered it incorrectly somehow?

     

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      The relashionship between tables is it this way?

       

      • GRikerWillig's avatar
        GRikerWillig
        Regular Visitor
        5 years ago

        It is. There are a bunch of other tables attached to each other in the backround, but those 2 are directly connected.