ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Searching for 3 variables (https://www.excelbanter.com/excel-programming/356351-searching-3-variables.html)

Dale

Searching for 3 variables
 
I would like to loop thru sheet; €œGI€ columns A, I & K row 1.
Search sheet €œRJE€ for matches,
(€œGI€ column A= €œRJE€= column C) 5 chars beginning with a 6
(€œGI€ column I= €œRJE€= column H).
(€œGI€ column K= €œRJE€=column A).
For a match to be considered correct, all 3 cells, row 1, from €œGI€ must
match the same row in €œRJE€.IF yes, colour the row green in €œRJE€.

Go back to €œGE€ and begin again at row 2, etc.

Before I begin trying to code this, could the search be done in a
multi-dimensional array, and if so how?



All times are GMT +1. The time now is 07:21 AM.

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