Forum Discussion

abfdjuk's avatar
abfdjuk
Icon for Helper I rankHelper I
3 years ago

create a lookup with two search values

I want to create a vlookup style expression where I am trying to do the following:

 

If column A (supplier) and column B (project) in table 1 match data in columns A (supplier) and B (project) in table 2 then show data in column C.

 

I've tried lookups and this doesn't seem to work. Is there an easy solution that I am missing?

 

Thanks

 

Dan

Need Help

2 Replies

  • bsheffer's avatar
    bsheffer
    Icon for Continued Contributor rankContinued Contributor
    3 years ago

    can your provide a visual mockup of what you want to do? if it is all in one visual you can create a measure using a if statement to return a value if matching occurs or blank if they don't match

  • AndrewPF's avatar
    AndrewPF
    Icon for Helper V rankHelper V
    3 years ago

    Concatenate your data in both tables, then merge based on the new variables. 

    Use the text trim functions to ensure you eradicate leading and trailing spaces.