LOOKUP FOR A SPECIFIC SINGLE OR SET OF SEARCH ARGUEMENTS AND IF FOUND RETURN A VALUE AND LOAD IT

I AM INTERESTED IN A LARGE SPREAD SHEET TO LOOK FOR ONE OR MORE SEARCH ARGUEMENTS AND MATCH IT IN A TABLE TO FIND THE CORRESPONDING RESULTANT CODE, OR VALUE TO RETURN TO A CELL OR ARRAY. EXAMPLE: S...