Working with dropdown list data define range and validate questions?

[cgmaster]

I created a dropdown list using the data define range from sheet 1 column B to sheet 2 column B. However I would also like the data from several of the cells on that same row to transfer to sheet 2 on the same row.

for instance on sheet 1 I have tools listed in column B with cutting speeds on column C and material on column D. On sheet 2 I have jobs where I need to pick that tool and I would like to transfer the cutting speed and material from sheet 1 that goes with the tool.

On my drop down list I pick the tool.

[Lupp]

“I created a dropdown list using the data define range from sheet 1 column B to sheet 2 column B.” How did you do that? A validity range shouldn’t accept a cuboid (something similar to a range, but spanning more than one sheet).

“…on sheet 1 I have tools listed in column B with cutting speeds on column C…”
To associate the content from an additional column for the same row as an item already chosen, you can use a combination of MATCH() with INDEX(), or, in appropriate cases the VLOOKUP function.