Help with using if and function

I have two spreadsheets. I want to make it such that if cell a1, b1, c1 in sheet 2, all match any 3 cells in columns a,b,c in sheet 1 (all three have to match) then the value of d1 in sheet 2 should be equal to the corresponding value d of the one it matched with in sheet 1.
By: Feranmi

Leave a Reply

Your email address will not be published. Required fields are marked *