Copying cells from another worksheet

M

Mark Rose

Hi i have a worksheet that has part no, desciption and cost in then on the
other worksheet i have a list of items with part no, description, and cost
on workshhet one if i select the description i want it to fill the other
cells with the part number and cost . i have created a avaidation that gives
me a list box with the equipment in but how do i link it to the cells.

Thanks

Mark
 
J

J.E. McGimpsey

One way:

Assume on sheet1 you have Part No. in column A, description in
column B and Cost in column C.

Assume that in sheet2 you have validation lists in column A that
list descriptions, and you wish to have Part No. in column B and
Cost in column C. Then in Sheet2:

B2: =INDEX(Sheet1!$A:$A,MATCH($A2,Sheet1!$B:$B,FALSE))
C2: =INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$B:$B,FALSE))
 
Top