How do I fill in an entire table with a vlookup type formula?

I am looking to fill in a table from another worksheet in the same workbook if a certain field is completed. How do I make that happen? For example, I have a drop down box in my Form 9589 and need to pull in specs from Eng Specs to populate once the Part No is completed by a drop down box in F2. I need boxes B10:C:21 to populate according to the Eng Specs.

Hi PTS, welcome to the forum.

In your workbook, can you show what your expected results would be, and state why?

I would like to search in the Eng Specs file for the part number. Currently this is just an example since there will be more part numbers going forward once I get this working. So example. In the Form 9589, when the Part No in F2 is filed in through a drop down list, it will then search in Eng Specs for the part and bring the corresponding inspection data into the form 9589 according to the part that is chosen. I hope the attachments have been updated the way I would like them to show. If not, I will get you any additional information you may need.

Your second file attachment is the same as the first, no? There is no "result" data appearing. You might try explaining it in words, too. For example:

I would like to type (or select from a combobox) a part number in cell F2 of the Form 9589 worksheet. When I do that, it should look for that part number in column A of the Eng Specs worksheet and retrieve the BP Zone and Blueprint Specification data for all matching rows. That data should show up in columns B (BP Zone data) and C (Blueprint Specification data) starting in row 10.

If that explanation is accurate, try the following:

1. On the Eng Specs worksheet, delete the value PTS 25001 from cell A1. Fill PTS 25001 into cells A2:A13. This way each row has a value to match against.
2. On the Form 9589 worksheet, select the merged cells in columns C:E from row 10 through 33. Un-merge them.
3. In cell B10 on the Form 9589 worksheet, enter the following array formula (confirmed with CTRL+SHIFT+ENTER, not just ENTER):

=IFERROR(INDEX('Eng Specs'!$A$1:$C$20,SMALL(IF('Eng Specs'!$A$1:$C$20=$F$2,ROW($A$1:$A$20)),ROW(1:1)),2),"")

4. In cell C10 on the Form 9589 worksheet, enter the following array formula (confirmed with CTRL+SHIFT+ENTER, not just ENTER):

=IFERROR(INDEX('Eng Specs'!$A$1:$C$20,SMALL(IF('Eng Specs'!$A$1:$C$20=$F$2,ROW($A$1:$A$20)),ROW(1:1)),3),"")

Adjust the A1:C20 and A1:A20 ranges shown to encompass all of your actual data on the Eng Specs worksheet. If you have 2810 rows of data, set it to something like $A$1:$C$3000 and $A$1:$A$3000.