Ask Your Question
0

Working with dropdown list data define range and validate questions?

asked 2019-02-12 06:51:10 +0100

cgmaster gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-12 14:36:40 +0100

Lupp gravatar image

updated 2019-02-12 14:37:47 +0100

"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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-12 06:51:10 +0100

Seen: 71 times

Last updated: Feb 12