ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NEED TO INCLUDE 2 COULUMS IN MATCH FORMULA (https://www.excelbanter.com/excel-discussion-misc-queries/137466-need-include-2-coulums-match-formula.html)

Stewcrew

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



All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com