# Copying a range of cells based on the selection of a drop down choice in another sheet

1. ## Copying a range of cells based on the selection of a drop down choice in another sheet

I have seen this question listed with similar sheets but I cannot get it to work for my workbook.

So this project just became slightly more complex. Same thought process, Chassis 1 Common Cause tab is the main input source. The Chassis 1 Top Ten will be selectable based on the selection of the user. All info should flow over with the drop down choice. I have attached the actual spreadsheet I am using instead of a template.

Complete workbook attached.

Jason

2. ## Re: Copying a range of cells based on the selection of a drop down choice in another sheet

Maybe try:

In Cell C3:
=IFERROR(INDEX('Chassis 1 Common Cause'!C\$3:C\$122,MATCH(\$B3,'Chassis 1 Common Cause'!\$B\$3:\$B\$122,0)),"")
You can copy this over to column H and then down.

In Cell J3: (It's the same formula, but it's not in a merged cell)
=IFERROR(INDEX('Chassis 1 Common Cause'!J\$3:J\$122,MATCH(\$B3,'Chassis 1 Common Cause'!\$B\$3:\$B\$122,0)),"")

In Cell J4:
=IFERROR(INDEX('Chassis 1 Common Cause'!J\$4:J\$123,MATCH(\$B3,'Chassis 1 Common Cause'!\$B\$3:\$B\$122,0)),"")

You can copy these formulas across.

then with both rows selected (J3:Y4), you can drag (or copy) down.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1