Vlookup for mutiple criteria

[jo.stanley]

I have two sheets for ease lets say they are called Master Data and Sup

All the data is on the Master Data Sheet so its here I want to find the values to return to Sheet Sup

I need to find out a supplier if 3 columns of criteria match on both sheets and then return the unique value on Master Data Sheet to Sup Sheet

Here are the references

Master Data A1 = BF Sup A1 =BF
Master Data B1 = TP Sup B1 = TP
Master Data T1 = Reason Sup D1 = Reason

Master Data C1 = Supplier and this is the information I am trying to find out if all the above match (These are unique and will not be more than one possible result)

 

[steve the fish]

Try this

=LOOKUP(2,1/(('Master Data'!$A$1:$A$1000=A1)*('Master Data'!$B$1:$B$1000=B1)*('Master Data'!$T$1:$T$1000=D1)),'Master Data'!$C$1:$C$1000)

Change ranges to suit but make sure they are the same length if you do.