Hi everyone,
I have a question. If I have 2 sheets in excel and on the 2nd
sheet I have a table that is divided in to few catagories, lets say Profile,
Item, and length. what I'm trying to do is on sheet 1, I want to type the
Item in one cell then it automatically display the Profile and the length in
to two different cells. I tried to play with the formulas a little but I
could not figure it out.