View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale Dale is offline
external usenet poster
 
Posts: 92
Default 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?