NEED TO INCLUDE 2 COULUMS IN MATCH FORMULA

S

Stewcrew

HELLO, I HAVE A FORMULA THAT WORKS GREAT, BUT I NEED TO HAVE THIS FORMULA
PROCESS A SECOND COLUMN WITH A DIFFERENT VALUE IN THE SAME MANOR THAT IT DOES
THE COLUMN LABELED CODES.

=INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDARY,0)-1,COLUMN(CODES)))

IS IT POSSIBLE TO ACOMPLISH THIS BY ADDING SOMETHING TO THIS FORMULA?

THANK YOU,

JIM
 
Top