I have:
In A1, "Kit A"
A2, "Kit B"
A3. "Kit C"
For the vertical lookup, I have
In X1, "Kit A" Y1 " (1) bolt, (14) screws, (1 nut)
x2, "Kit "C" Y2 " (2) handles, (1) Wheel, (1) axle
I enter the components as they are sent to me in Column "Y". Which are not in numeric order.
What I want is to be able to do a vertical lookup find the matching unit and then post into the comment box in column "A" the data from column "Y"
This will allow anyone to see the component detail of unit.
Thanks for your usual support.