What I am needing seems quite complex to me. I would greatly appreciate with this one.
I need a formula (probably an array) that will list horizontally from left to right starting with cell H2, and continuing listing as needed. (continues to I2, J2, K2, ETC. as needed.)
Using the value in E2 of the “UNIQUE MODELS” worksheet, search column D of the “EQUIPMENT LIST” worksheet. When the value is found, map back to H2 the value in column B of “EQUIPMENT LIST”.
Note, the value in column B may be found in multiple rows, so only map back unique values from column B, starting in H2 and continuing across until no more unique values are found.
I need a formula (probably an array) that will list horizontally from left to right starting with cell H2, and continuing listing as needed. (continues to I2, J2, K2, ETC. as needed.)
Using the value in E2 of the “UNIQUE MODELS” worksheet, search column D of the “EQUIPMENT LIST” worksheet. When the value is found, map back to H2 the value in column B of “EQUIPMENT LIST”.
Note, the value in column B may be found in multiple rows, so only map back unique values from column B, starting in H2 and continuing across until no more unique values are found.