Look up multiple values from table and return another value

What I am trying to do is use a VLOOKUP or something of the sort on another worksheet so that when someone types M-02 for Item #, 1 for Revision #, and 2 for Release #, all of the other information will just fill into other cells so they will be able to see the whole record on one page.

See if the attached is of help. This VLOOKUP formula uses three criteria.

=VLOOKUP($A2&$B2&$C2,Sheet1!$A$2:$F$5,4)