create a lookup with two search values

[abfdjuk]

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

[AndrewPF]

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. 

[bsheffer]

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