Copying Data from 1 Sheet to Another

[saq7792]

I have a sheet that contains a master list of products, locations, & delivery days. I want to set up a second sheet where I can manually populate the item name & automatic have the location & delivery info populate.

For example, based on the attached worksheet, if I type Apples into A2 on the "Ordering Sheet" sheet, I want B2 to populate with "1" & C2 to populate with "Monday".

Thanks in advance for the help!

[bob33]

See attached file.
Your master sheet has to have the data in Column A in alphabetical order.

I added a list to your second sheet for fun.

[bob33]

Saq,
Did this help?
Bob

[rcane]

I have a sheet that contains a master list of products, locations, & delivery days. I want to set up a second sheet where I can manually populate the item name & automatic have the location & delivery info populate.

For example, based on the attached worksheet, if I type Apples into A2 on the "Ordering Sheet" sheet, I want B2 to populate with "1" & C2 to populate with "Monday".

Thanks in advance for the help!

On the ordering sheet, you can put this in B2:

=IF(ISERROR(INDEX('Master Sheet'!B:B,MATCH($A2,'Master Sheet'!$A:$A,0))),"",INDEX('Master Sheet'!B:B,MATCH($A2,'Master Sheet'!$A:$A,0)))

Then drag it to C2, and the appropriate columns will automatically change.

The first part (with the ISERROR) is just to keep it clean for when you don't have an item typed in the ColumnA (which gives an error message that looks cluttered).


Also there are ways to make your fruit list an actual list so you needn't type the names on the ordering sheet--just dropdown and select.
Also also, if you want, there are ways to make that even cleaner (without using tables) so you can reserve the entire Column A for your items but only have the dropdown list display those items you have entered on the Master Sheet.