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?
|