Please look at the formula used in cell A2, A3, and A4.
I duplicated that formula into cells B23 and B24
When you type in a value that is equal to cells D1:I1, in cell A1 it will copy the cells under that value into cells A2:A4.
(Example: Type in "check" in A1 and it will populate "A"into cell A2, and "B" into cell A3, and "C" into celll A4.)
If I tpye "SL100PARLIST" into cell B22 it SHOULD populate "N/A" into cell B23, but it doesn't.
The formula works in cell A2 but doesn't work in cell B23.
What am I doing wrong?
The person who made the formula in cell A2 used an array, I don't believe this is used in cell B23.
Could you please help me get the formula in cell B23 to work and function just the formula in cell A2?
I want it so when I type a name in B22 that matches a name in cells M23-AW23, it will copy the cells under that cell into cells B24-B33.
Does this make sense?
Thank you so much for any help you can send my way :)
Solved by F. C. in 27 mins