![]() |
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