View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stewcrew Stewcrew is offline
external usenet poster
 
Posts: 8
Default NEED TO INCLUDE 2 COULUMS IN MATCH FORMULA

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,SECONDAR Y,0)-1,COLUMN(CODES)))

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

THANK YOU,

JIM